March 21, 2006 at 2:16 am
Dear all
What is the common method to backup a dts-package.
Are dts-packages stored in a dts-system database? When yes where and how do you restore a dts-package if needed.
Help is very appreciated.
Andre
March 21, 2006 at 7:09 am
I save them as vbscript and then run from within VB6 or Access if I need to recreate a package. (Package/SaveAs/Location = Visual Basic File)
March 21, 2006 at 10:13 am
DTS package data is stored in the MSDB database so a backup of that backs up packages. The drawback is when you want to restore a single package, you'll have to find another instance to restore the database to.
I much prefer Metra's method. You can also store packages as structured storage file with a .dts extension. See "How to save a DTS package..." in BOL.
Greg
Greg
March 22, 2006 at 7:11 am
Using the Save As structured storage file (.DTS) offers the most flexibility by keeping the layout and annotations of the package intact.
There are other tools such as DTS Backup 2000 and DTS Package Compare/Mover that also are viable options.
-Mike Gercevich
March 22, 2006 at 8:33 am
March 22, 2006 at 9:45 am
You create a new project with that bas file. Add references to these three libraries:
Microsoft DTS Custom Tasks Object Library
Microsoft DTSDataPump Scripting Object Library
Microsoft DTSPackage Object Library
You should then be able to run the dts package (sub Main should be in your .bas file).
March 24, 2006 at 4:42 am
Why not just use a tool called DTS Backup??
For more info check...http://www.sqldts.com/default.aspx?242
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply