Unable to open DTS package after install of SQL Server 2005 Migration
Hi All,
we have migrated from exiting sql server 2005 to new sql server 2005, after we succussfuly migrated we are unable to open the few DTS packages? Even i installed 2000 dts compatability tools? Do i need to get the Enterprise manager on New server?
Thanks,
Maddy
August 16th, 2012 3:09pm
SO what is the error you are getting ?Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click
"Mark as Answer" and "Vote as Helpful"
on posts that help you.
This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2012 5:48pm
did you select SSIS feature when installing the new SQL Server ?
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
August 17th, 2012 8:53am
Ahmed,
I am receiving Error Description : The DTS host failed to load or save the package properly
Thanks,
Maddy
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2012 2:18pm
We are using only DTS packages for this application
Thnaks,
Madhu
August 17th, 2012 2:20pm