We have a moderately complex SSIS package that uses a script task to dynamically create a Transfer SQL Server Object task, which then moves data and schema of a varying definition
from source to destination. The SSIS package was written in BIDS 2005.
The source system is still SQL 2005 (with latest updates) and the destination system is now 2008r2 (with latest updates).
When the package run, we get the following error when we try to execute the dynamically created transfer task: Description: Execution failed with the following error: "Version90 database compatibility level is not supported.".
sp_dbcmptlevel for the source and destination databases returns "The current compatibility level is 90.".
Master on the target system is predictably at level 100.
This leads to several questions:
View Complete Post