all groups > sql server dts > november 2004 >
You're in the

sql server dts

group:

Transfer Sql Server DTS Packages !?!


Transfer Sql Server DTS Packages !?! Vinny Vinn
11/30/2004 10:37:02 AM
sql server dts:
How can i transfer a DTS Package from one machine to another?(Is there a file
containing the script that runs the package that must be moved?).

Thanks In Advance,
Re: Transfer Sql Server DTS Packages !?! Vinny Vinn
11/30/2004 12:25:04 PM
platinumbay,

Thanks,However I was wondering if there is a way i can do it without using
an outside tool?

tia,
Vinny

[quoted text, click to view]
Re: Transfer Sql Server DTS Packages !?! platinumbay
11/30/2004 1:46:26 PM
There is a great tool I used recently called DTSBackup 2000.

http://www.sqldts.com/default.aspx?t=6&s=105&i=242&p=1&a=0

You can save your DTS packages to files, and then load those files on the
new server with the same tool.

- Stephen Andrews

[quoted text, click to view]

Re: Transfer Sql Server DTS Packages !?! Allan Mitchell
11/30/2004 8:52:06 PM
We use the DTS API when doing the move if that counts <grin>

You can use DTS itself if the packages are stored in MSDB.

See this article

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


[quoted text, click to view]

AddThis Social Bookmark Button