I was trying to transfer a SQL Server 2000 database to SQL Server 2005 using SQL Server Objects Task. However, The following error message was encountered:
"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".“
Is there any other way possible to achieve this(transfer of database). The objects to be transferred are tables, views, stored procedures, user data types, and user-defined functions. The logins need not to be transferred. Start Debugging: SSIS package "unittest2.dtsx" starting. Error: 0xC002F325 at SQL Server-Objekte kopieren, Transfer SQL Server Objects Task: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..". Task failed: SQL Server-Objekte kopieren Warning: 0x80019002 at unittest2: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "unittest2.dtsx" finished: Failure. The program '[4272] unittest2.dtsx: DTS' has exited with code 0 (0x0).
I think this is likely better for the management tools forum - they own the transfer objects wizard and tasks ...
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1
Donald
No comments:
Post a Comment