Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Package upgrade

Author  Topic 

Constraint Violating Yak Guru

272 Posts

Posted - 2015-02-12 : 19:35:17
Recently Upgraded SSIS package from 2005 to 2008R2 Server's Instance using .DTSX extension on its completion of entire package I found with errors and could able to decipher them.

At the end there were no RED Letter Errors but could not run the package from the Integration Services.

Can anyone let me know please.

Posting Yak Master

120 Posts

Posted - 2015-02-18 : 18:29:55
The best thing would be to export it to the file system and open it with Visual Studio or BIDS. Then you can debug through it and see where it's having issues.
Go to Top of Page

- Advertisement -