var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How use SQL SSIS 2008 to move data between SQL 2005 servers?
I'm trying to use a SSIS package of the SQL Server 2008 Business Intelligence Development Studio.
I did add the Control Flow Item: Transfer SQL Server Objects Task becuase I need to copy all tables between 2 servers.
I configure in this task 2 SQL 2005 servers.
When I run the package several messages appear: There are no Logins to transfer... Truncating table... But after all truncates appears this error:
Transfer SQL Server Objects Task: Execution failed with the following error: "Version90 database compatibility level is not supported.".
How use SQL SSIS 2008 to move data between SQL 2005 servers in a pcakage?