DTS packages - backin them up

[Paul]

Does anyone know how DTS packages are backed up. Does peforming a DB backup also backup the DTS packages ? Can they be scripted ?

many thanks

[Ray Miao]

Backup msdb.


------------
Paul at 3/7/01 6:05:14 AM


Does anyone know how DTS packages are backed up. Does peforming a DB backup also backup the DTS packages ? Can they be scripted ?

many thanks

[phil_mccormack]

Take a look at www.sqlconsultants.co.uk

there's some example code to script out DTS Packages using calls to SQL-DMO and the DTS API, in particular, the SaveAsStorageFile method for a DTS Package. This will script them out individually if needed.


------------
Ray Miao at 3/7/01 8:41:50 AM

Backup msdb.


------------
Paul at 3/7/01 6:05:14 AM


Does anyone know how DTS packages are backed up. Does peforming a DB backup also backup the DTS packages ? Can they be scripted ?

many thanks