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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2008-07-07 : 21:14:44
|
| Folks:We recently upgraded our database server from 2000 to 2005 and we also migrated the DTS packages to SSIS. For some reason we have some issues with the migration especially the tranformations (mappings) moving data from file to database (mappings show all weird in SSIS) and shows correctly in SQL 2000. Question: Is there a workaround where we could atlease run the 2000 packages. All of our packages are stored in legacy. How can I run these packages? What is the command to do so. My understanding is the with DTEXEC I can run only 2005 SSIS packages....Thanks ! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-07 : 22:21:04
|
| Yes there is Execute SQL 2000 DTS task. Active scripts with COM objects are not supported in SSIS. You need to rewrite in Script task. |
 |
|
|
|
|
|
DTS to SSIS