|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Scripting a DTS package
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.
|
|
#2
|
|||
|
|||
|
so why don't you use the possibility to output the dts script as vb code? , thatway you've got an script which you can execute on any server
|
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Scripting a DTS package |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|