SSIS : Version80 database compatibility level is not supported. -
11-24-2005
, 01:16 AM
When I try n run a DTS [dtsx : ) ] with "Transfer SQL Server Objects" Task,
it gives me the above error. The DTS is trying to transfer some tables from
sql 2000 server to SQL 2005 server.
The full error is here,
------------------------
[Transfer SQL Server Objects Task] Error: Execution failed with the
following error: "Version80 database compatibility level is not supported.".
------------------------
If i set the compatibility level of 2k5 databse to 90, it works fine.
Does this mean tat I can't use "Transfer SQL Server Objects Task" with an
database with compatibility level 80?
thanks |