SFWolverine
asked on
SQL 2008 SSIS package to move data from SQL 2005 server
i'm getting the following error message: Transfer SQL Server Objects Task: Execution failed with the following error: "Version90 database compatibility level is not supported.".
I'm just copying over some tables with primary keys.
I'm just copying over some tables with primary keys.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When I execute the following command "sp_dbcmptlevel" in SQL Server 2005 i get the following:
Valid values of the database compatibility level are 60, 65, 70, 80, or 90.
When I execute the following command "sp_dbcmptlevel" in SQL Server 2008 I get the following:
Valid values of the database compatibility level are 80, 90, or 100.
But when i execute the SSIS package i get the following:
"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Version90 database compatibility level is not supported.". "
The sql server 2005 is used by hundreds ...
Valid values of the database compatibility level are 60, 65, 70, 80, or 90.
When I execute the following command "sp_dbcmptlevel" in SQL Server 2008 I get the following:
Valid values of the database compatibility level are 80, 90, or 100.
But when i execute the SSIS package i get the following:
"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Version90 database compatibility level is not supported.". "
The sql server 2005 is used by hundreds ...
ASKER