Automate DTS package script - 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)

Automate DTS package script

Author

Topic

scottpt
Posting Yak Master

186 Posts

Posted - 2004-08-09 : 14:46:21

I have to move about 300 packages from one server to another and was wondering is anyone had a way to automate the writing of these to files.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-09 : 14:50:13

Nigel does:

http://www.nigelrivett.net/SaveAllDTSPackagesToFiles.html

Tara

Hyukevain
Yak Posting Veteran

66 Posts

Posted - 2004-08-09 : 21:57:27

Use this program to export your DTS Package, server to server, server to file.... :
http://www.sqldts.com/dtsbackup/

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-08-09 : 22:50:22

It you're using VB6 it is easy.

set rst = cn.Execute("Select Distinct name from msdb.dbo.sysdtspackages")
Do While not rst.eof
    dmo.LoadFromSQLServer "<sourceservername>", , , DTSSQLStgFlag_UseTrustedConnection, , , , rst(0)
    dmo.SaveToSQLServer "myServer", , , DTSSQLStgFlag_UseTrustedConnection, , , , rst(0)
    rst.MoveNext
Loop

scottpt
Posting Yak Master

186 Posts

Posted - 2004-08-12 : 14:17:55

Thanks for the help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources