MS SQL Server - where to keep DTS from SQL 2000 in 2005 if I don't want to change them

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

where to keep DTS from SQL 2000 in 2005 if I don't want to change them

t2581@hotmail.com

2005-11-30, 11:23 am

Hi,
reading BOL of 2005 and have few questions about dts and SSIS

question #1
if I don't want to upgrade my DTS to SSIS ,no way I can save it in
msdb of 2005 and I have to do following

1. DTS package have to be saved as a COM-structured storage file
2. execute dts as dtsrun /Ffilename /Npackage_name /Mpackage_password

Am I missing some options ?

question #2
If I want to modify package in 2005 I have to do following
1. Export package to file from msdb
2. Use Studio to modify and test it
3. Drop package from msdb
4. Import package to msdb from file

Thanks

Alex

Sponsored Links