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.
| Author |
Topic |
|
drewj840
Starting Member
3 Posts |
 Posted - 2003-08-12 : 13:23:15
|
| Is it possible to script a DTS package so that it can be recreated on another server? I know you can output a DTS package to a structured file or to VB (6.0?) code, but I want to script the DTS package in the same way that a table or stored procedure is scripted. The purpose is to be able to run a script created on a test server on a production server and to also use this for disaster recovery. I have searched high and low and cannot find any way to do this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-12 : 13:36:13
|
| You could copy the contents of msdb..sysdtspackages to transfer it from one server to the next. DTS packages are stored in that system table.Tara |
 |
|
|
drewj840
Starting Member
3 Posts |
Posted - 2003-08-12 : 14:31:04
|
| How is this done? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-12 : 14:55:38
|
| Just bcp the data out into a file, then bcp the data in on the server from the file. You also could setup a linked server and then run INSERT INTO DestinationServer.msdb..sysdtspackages SELECT * FROM msdb.sysdtspackages. Tara |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-13 : 07:02:46
|
| What was wrong with the structured storage file method?Jay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-13 : 12:26:24
|
| He probably wants to automate it.Tara |
|
|
|
|
|
|
Scripting a DTS package