I am attempting to use the "Transfer SQL Server Objects" in the package
designer for SQL Server Business Intelligence Development Studio to copy
objects from a SQL 2000 server to a SQL 2005 server. When I attempt to run
this step I recieve this output complete with the error message in my subject:

================================================== ==
SSIS package "Import.dtsx" starting.
Information: 0x4002F418 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Logins to transfer.
Information: 0x4002F362 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Rules to transfer.
Warning: 0x8002F368 at DatabaseName Import, Transfer SQL Server Objects
Task: View "vwNotifyUpdate" already exists at destination.
Warning: 0x8002F368 at DatabaseName Import, Transfer SQL Server Objects
Task: View "vwCurrentUsers" already exists at destination.
Warning: 0x8002F368 at DatabaseName Import, Transfer SQL Server Objects
Task: View "vwMenuBuilder" already exists at destination.
Information: 0x4002F358 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Stored Procedures to transfer.
Information: 0x4002F374 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no User Defined Functions to transfer.
Information: 0x4002F378 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Defaults to transfer.
Information: 0x4002F382 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no User Defined Data Types to transfer.
Information: 0x4002F386 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Partition Functions to transfer.
Information: 0x4002F390 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Partition Schemes to transfer.
Information: 0x4002F394 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no Schemas to transfer.
Information: 0x4002F398 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no SqlAssemblys to transfer.
Information: 0x4002F402 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no User Defined Aggregates to transfer.
Information: 0x4002F406 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no User Defined Types to transfer.
Information: 0x4002F410 at DatabaseName Import, Transfer SQL Server Objects
Task: There are no XmlSchemaCollections to transfer.
Error: 0xC002F325 at DatabaseName Import, Transfer SQL Server Objects Task:
Execution failed with the following error: "Version80 database compatibility
level is not supported.".
Task failed: DatabaseName Import
SSIS package "Import.dtsx" finished: Success.
================================================== ==

I have tried everything that I am aware of to make this work and have been
unable to do so. I also have searched the net and I have had no luck finding
anyone that has even a thought of a solution. So I guess I am really asking
if it is possible to make this copy objects work across SQL 2k & SQL 2005?
If it is not possible via the copy objects task, how is it done?

-Mabuti

Found a solution:

Run this stored proc to set the compatability level to 90:

EXEC sp_dbcmptlevel DatabaseName, 90

The SQL 2000 databases that were brought up to SQL 2005 during the upgrade
still have the compatability level of 80. Changing this to the new level of
90 solves the issue and allows the SSIS packages to run properly on that
database.

-Mabuti

you can do the same by right clicking on the databse, go to propertioes,
option, and change the compactibility from 80 to 90.

THANKS

"Mabuti" wrote: