August 15, 2006 at 11:30 am
How is DTS information stored? Is there a file name and extension for each package? Please enhance my understanding. . . . .
August 15, 2006 at 12:20 pm
DTS packages are stored in the msdb.dbo.sysdtspackages table.
You can save your DTS packages as a structured storage file (.dts extension) by clicking the Package/Save As menu and selecting "Structured Storage File" in the location drop-down box.
August 16, 2006 at 3:00 am
Hi, using structured staorage files is a useful way of transporting packages from installation to new installation. However, if you have password protected your original package, when saving it as a structured storage file remeber to re-enter your passwords. failure to do so will allow anyone to access the contents of the file and hence open, edit and run the packages you have created.
Regards Duncan
August 16, 2006 at 8:47 am
Thanks guys, your answers provided what I asked and more.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply