Showing posts with label fileskept. Show all posts
Showing posts with label fileskept. Show all posts

Thursday, March 22, 2012

DTS Packages

Hi
When DTS packages are created, where do the physical location of the files
kept on the severThe 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

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