473,554 Members | 3,173 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can a DTS package be scripted or transferred to another server?

I have production SQL Server database that must be moved to a new
machine. There is a fairly complex DTS package on the original server
that is used to handle the weekly updates to the database.

Is there a way to export this DTS package in order to set it up on the
new machine as well?

Best Regards,

Warren Wright
Scorex Development Team
Jul 20 '05 #1
3 6208
wa***********@u s.scorex.com (Warren Wright) wrote in message news:<84******* *************** ****@posting.go ogle.com>...
I have production SQL Server database that must be moved to a new
machine. There is a fairly complex DTS package on the original server
that is used to handle the weekly updates to the database.

Is there a way to export this DTS package in order to set it up on the
new machine as well?

Best Regards,

Warren Wright
Scorex Development Team


http://www.sqldts.com/default.aspx?6,105,204,0,1

The June issue of SQL Server magazine (http://www.sqlmag.com) had a
good article on making DTS packages portable between servers.

Simon
Jul 20 '05 #2
wa***********@u s.scorex.com (Warren Wright) wrote in message news:<84******* *************** ****@posting.go ogle.com>...
I have production SQL Server database that must be moved to a new
machine. There is a fairly complex DTS package on the original server
that is used to handle the weekly updates to the database.

Is there a way to export this DTS package in order to set it up on the
new machine as well?

Best Regards,

Warren Wright
Scorex Development Team


You can, when designing the DTS Package, select "Save As..." and
change the "location" to a structured storage file. You can then
import this file onto your production server. If you scripted all
your local connections as "(local)", then this should be the end of
the story, if not, you'll need to open it and change your local
connections to the production server.

Hope this helps

Hodge
Jul 20 '05 #3
Warren

Try this link.

http://www.sqldts.com/default.aspx?6,105,204,0,1

Hope that helps

John
Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3622
by: Jim Andersen | last post by:
Hejsa, Jeg har lavet en DTS-package og den virker når jeg kører den pr. håndkraft, men når den køres af SQL Server Agenten, fejler den. Det skal også lige siges at jeg har brugt guiden til at oprette en "standard" vedligeholdelse/backup rutine. Den går heller ikke så godt. Den kører optimization's men ikke integrity check eller backup...
5
13703
by: Jim Andersen | last post by:
Hi, I made a DTS-package and it works when I execute it manually, but when it is run by the SQL Server Agent, it fails. I have use the guide to create a maintenance plan. That doesn't work so good either. It runs Optimizations, but not integrity checks or backups (probably because integrity checks failed). The following from the log...
0
1273
by: Jason Smirnow | last post by:
I posted this to the SQL Server group but got no good responses, so I'm trying here... I have a DTS package I am kickig off from a C#.Net applcation that imports a tab delimited text file created by the C# app. I can successfully kick off the DTS package from my development machine, run the package, and everything works great. When I...
3
1576
by: MikeH | last post by:
I have the weirdest problem with an Access 97 database... The application comprises the usual front-back split database. It's built around Access 97 and had been running without serious problems for around seven years. The back-ends are replicated across two servers (althugh I don't think this is a replication problem). Around two weeks...
3
2751
by: Shmulik | last post by:
I have an application written in C# that creates a queue of items to process, connects via a TCP connection to a server on a Unix box, and then passes data files to the Unix box for processing (cluster) - normally this works fine. However, on the front end, another Unix system generates and transfers files to the DotNet application...
7
2034
by: chad | last post by:
let's say I'm transferring a large file like 100MB over to a folder. The program detects when the file arrives. However, I can't figure out how to know when the file is totally transferred over. One unsuccessful method is to... dim fi as new fileinfo(newfile) fi.length returns the supposed size of the file. But it correctly
2
1911
by: LimaCharlie | last post by:
Hi everybody, Just want to ask how can I copy a DTS Package? Something like "Save As"...saving a DTS Package to another package name in the same server, or copying a DTS package to another server. What I am doing right now, is I create the whole package again just to have another copy of it. Same question with a Job. Thank you so much.
3
6415
by: Steve | last post by:
Hi All I downloaded Sql server 2005 express SP2 and attempted to modify the Bootstrapper package files as I did with SP1 When i try to install SQL server as part of my VS 2005 deployment app I get an error at the end of the SQL server install phase 'Invalid endpoint'. (Note SQL server express gets installed OK) If I run SQL server...
0
2538
by: Jack Lee | last post by:
I try to set a job to run a DTS package, failed. My environment is SQL Server 2000 sp4 on windows Server 2003. There is a local window group called Dev_accnt including member SQLTesting who is a global account of domain Jackson. local group Dev_accnt assigned in SQL Server with Login name: LocalMachine\Dev_accnt, type: windows group....
0
7584
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7512
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7783
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8023
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7879
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5426
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5144
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2009
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1117
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.