dbTalk Databases Forums  

SSIS : Version80 database compatibility level is not supported.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS : Version80 database compatibility level is not supported. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
k_s
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.