• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1096
  • Last Modified:

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.

0
SFWolverine
Asked:
SFWolverine
  • 2
2 Solutions
 
rajvjaCommented:
try this

Version90 database compatibility level is not supported
0
 
SFWolverineAuthor Commented:
how do i make it compatible...
0
 
SFWolverineAuthor Commented:
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 ...
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now