Where are DTS's Stored in SQL

[GJP55]

Can anybody tell me where DTS's are stored inside SQL. (ie. part of the Master database ? or Model database ? , etc).

 

[JohnDTampaBay]

Check out BOL index, DTS > Overview > DTS Overview > Managing a DTS Package > Saving a DTS Package.

In short, You can save a package to Microsoft® SQL Server, SQL Server 2000 Meta Data Services, a structured storage file, or a Microsoft Visual Basic® file.

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[mrdenny]

They are storred in the MSDB database.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[GJP55]

thats great, thanks for your help