Wednesday, March 21, 2012

DTS Packages

Hi
When DTS packages are created, where do the physical location of the files
kept on the sever
The default option for saving DTS packages, is to save them to SQL Server,
in which case they get stored in the table msdb.dbo.sysdtspackages.
Alternatively you can save them to files, or .vbs files or to repository.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Raks" <Raks@.discussions.microsoft.com> wrote in message
news:FE0DD431-B9C5-43E3-9020-34CBFA017E26@.microsoft.com...
Hi
When DTS packages are created, where do the physical location of the files
kept on the sever

No comments:

Post a Comment