Friday, February 24, 2012

Getting error working with Transfer SQL Server Objects Task

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..".“

can anyone suggest me what is the error here?

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.
The output we are Getting is:-

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