November 12, 2004 at 9:03 am
How would I go about saving off a copy of a DTS package that I've created through Enterprise Manager? When you create these packages- where are they stored? When I saved them, the location was set to SQL Server. I thought maybe I could save them off by scripting them out, but I can't seem to figure out how to do this.....
November 12, 2004 at 9:16 am
In DTS Designer, when you select Package -> Save, you can choose a location of SQL Server, structured storage file, or VB file. If you choose to save in SQL Server, the package is saved in the msdb database. If you choose structured storage file, you'll be prompted to choose a directory to save to.
So, if you want to store the package outside of SQL Server, choose the file option. You can save the package twice to have a copy in msdb and in a file. Be aware that a package saved as a file can still only be opened in DTS Designer.
Greg
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply