June 6, 2008 at 9:15 am
Hi all. We recently migrated our local sql 2000 box to a new sql 2005 box, and successfully migrated the old DTS packages. Unfortunately, to run those scheduled pacakges while we convert them to SSIS, we had to created SSIS packages that wrappered the DTS.
Som eof those aren't running because they're copying tables from remote sql 2000 servers that aren't going to be converted to SQL 2005 any time soon.
The error I'm getting in the SSIS is this:
Error: 0xC002F325 at Copy Remote Tables, Transfer SQL Server Objects Task: Execution failed with the following error: "Version80 database compatibility level is not supported."
I understand that you have to somehow set the compatability, but HOW do you do this? I'm developing the SSIS in Studio '05 Business Intelligence. I do have all the legacy tools installed, but I'm still unable to find an option or preference to set backwards compatability.
Any help would be much appreciated!
June 6, 2008 at 10:02 am
"I understand that you have to somehow set the compatability, but HOW do you do this?"
Unfortunately, you can't change the compatibility level to 9.0 while the database is still in a SQL 2000 instance. I've not found a way to make the Copy SQL Server Objects task work between SQL 2000 and SQL 2005.
I suggest you change the packages to just import data from the SQL 2000 tables rather than copying the tables themselves.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply