Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CBurgess
Starting Member
6 Posts |
 Posted - 2004-03-22 : 01:58:32
|
| I've been stuck with the glamorous task of backing up and migrating scores of DTS packages to files. The problem is, they want previous versions. Through research and experimentation, the textcopy tool has proven to work well, though it only saves the latest version. Does anyone know how to save several versions to a single file? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-03-25 : 21:46:26
|
| A couple of options:Check out the Microsoft DTS Object library in VB/C. There is a function called LoadFromSQLServer that allows you to load a particular version of a package. You can then back it up to a structure storage file.Another option (although probably not that reliable) is to back up the msdb..sysdtspackages table. This contains the binary representations of your DTS packages, including version history.HTHTim |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-26 : 12:21:00
|
| You can bring up different versions through Enterprise Manager. Right click on your package and go to Versions. Select which one you want, then select edit. Then inside the DTS package, go to Package, then to Save As... Save your package to a file. This is very manual though.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-26 : 23:27:02
|
| I usually do thiss using the dts object library and a VB app.The problem is that it losses the graphics format - but if you can live with that isit's quite easy to code.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
CBurgess
Starting Member
6 Posts |
Posted - 2004-03-30 : 00:48:55
|
quote:
Originally posted by nr
I usually do thiss using the dts object library and a VB app.The problem is that it losses the graphics format - but if you can live with that is it's quite easy to code.
IIRC, it's because the SaveToFile function's viewstate input doesn't actually work at all.I've actually bit the bullet and created a *really simple* GUI frontend for the textcopy tool. Copies the graphics and text connotations perfectly and all, but of course, I haven't yet figured out the multiple versions problem. If you want a copy of the code, to save yourself the trouble, give us an email at c.burgess at unsw dot edu dot au. This code is supplied as is though.Maybe if you want to take a look at the HEX of a multi-version .dts file you could hack a multi-version save-to-file from this code?It seems like quite a popular problem, so I'm surprised they haven't fixed the object model function..../me pines for Yukon to fix things. |
|
|
|
|
|
|
|
|
DTS Backup