Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS problems

Status
Not open for further replies.
Beesknees

Beesknees

Programmer
Feb 27, 2001
95
GB
How can I transfer a DTS package from one SQL Server to another? I don't want to recreate it manually.
Thanks.
 
Sort by date Sort by votes
Open your DTS package and then go to Package:Save As...

From the pop screen displayed you have an option to pick out the server name of where you want to save your DTS package.

Rick.
 
Upvote 0 Downvote
Easy as that? Thanks. I did actually end up saving it to a file and then opening up the file in the other server and saving it to the server that way.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G12Consult
  • Locked
  • Question
Problems with SP
Replies
5
Views
227
Olaf Doschke
Olaf Doschke
VAST39
  • Locked
  • Question
Problems Creating a Query with Multiple Counts
Replies
3
Views
160
gmmastros
gmmastros
WMXTeam
  • Locked
  • Question
Convert DTS package to .Net
Replies
0
Views
163
WMXTeam
WMXTeam
egstatus
  • Locked
  • Question
Problems with RTRIM when creating a field from other fields in SQL
Replies
2
Views
133
egstatus
egstatus
smatthews
  • Locked
  • Question
Getting Server Does not Exist Error on SQL 2k DTS package running on SQL 2005
Replies
5
Views
213
smatthews
smatthews

Part and Inventory Search

Sponsor

Back
Top