Exporting DTS package - SQL Server Forums

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)

Exporting DTS package

Author

Topic

joelatongue
Starting Member

3 Posts

Posted - 2005-01-26 : 09:05:00

Hi,

I would like to know how to Import/Export DTS Package.
I have already created some DTS package with DTS Designer, I have save them into files named MyDTS.dts
But I cannot find how to import them into another SQL Server.
I am using SQL Server 2000 on windows 2000/XP

Thanks in advance

Bye............Rémi.
PS : I'm sorry for my poor English.

jwmoline
Starting Member

1 Post

Posted - 2005-01-26 : 09:50:58

I don't know about Importing, but if you have both servers listed in Enterprise Manager you move the package from one server to another by:

Right click on the package and select "Design Package"
Select Package->Save As
Change the referenced server and click save

You will probably have to refresh the view beofre you'll see the package on the new server.

Hope this helps.

joelatongue
Starting Member

3 Posts

Posted - 2005-01-26 : 10:03:59

Thanks a lot, but I cannot use your solution because I cannot put the two servers on the same Enterprise Manager.

Bye..........Rémi.

shuvi
Starting Member

4 Posts

Posted - 2005-02-07 : 11:39:50

In order to import the dts package all you have to do is save it to a location you can get to. Then open Enterprise Manager and go to Data Transformation Services folder in the tree. Right click it and select Open Package. That should open the package you had saved and then simply do a save as but this time use SQL Server and storage!
Hope that helps!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources