There doesn't seem to be a specific group covering legacy subsystems so I thought I would post this in here.
I have several hundred of these to import that are going to be left to run as they are until such time somebody has the time to migrate them to SSIS.
I have to say I'm not look forward to doing them one at a time using the brain dead UI (it folds up folders behind itself causing another two mouse click between each import
). Is there a way of automating this import?
Thanks.
DTS packages are stored in exactly the same location in 2005 as they were in 2000, after all it is just a backward compatibility feature. If you upgraded a system there would be no change, If you are migrating as part of the "upgrade" then just copy the contents of msdb..sysdtspackages.
This may explain more about DTS storage
Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)
Thanks for the guidance.
I actually found a utility by following your link above. The tool is called DTSbackup2000. It's more than a backup tool as it also transfers DTS packages between servers, including SQL Server 2005 targets.
Here is a direct link to the download: http://www.sqldts.com/download/DTSBackup2000.msi
It has worked for me and saved me a lot of clicky, clicky with the UI!
No comments:
Post a Comment