Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Transferring Local DTS Packages

Author  Topic 

richards
Starting Member

2 Posts

Posted - 2002-03-06 : 16:00:14
I am trying to copy developed DTS Packages from a main server to a laptop so I can work on them at home. I am new on working with DTS packages and as they are outside of a specific database, I am not having luck on moving them to a different server registered on the same maching.

JamesT
Yak Posting Veteran

97 Posts

Posted - 2002-03-06 : 16:19:13
Could you try saving it as a dts file? Look at books on line at: Saving a DTS Package

Go to Top of Page

yakoo
Constraint Violating Yak Guru

312 Posts

Posted - 2002-03-06 : 16:46:26

When you are in DTS designer choose Package -> Save As... and specify which server it should be saved to.

Go to Top of Page

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-08 : 13:43:01
Yes, you can "Save as ... " to a OLE structured storage file. The trick is figuring out how to open the package on the destination machine

Go to Top of Page
   

- Advertisement -