Transfer SQL Server Objects Task gives error with SQL Server authentication

Hot Topic

Using EFS with database files.
Migration Problem with NS SQL 2000 to NS SQL 2005
Simple copy table data fails after 7973680 rows
Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
Full Text search in SQL Server 2005 Express?
Error using FTP Task
Two Questions (email from SQL & download contents)
updating telephone column
using package variables as parameters in Execute Sql Task
login failed

SQL Server

Parameter Information cannot be derived from SQL statements with sub-select queries
Concatenate field based on unique id.
Getting DataType of a IDTSCustomProperty90 object
Best way to restrict a varchar field not to contain spaces?
Help with ##table
When (how) does Compatibility level for master change to 90?
how to conditionally get the data
Report design scenario
Currency conversion wizard - performance
Does anyone have a script to reset SQL login passwords?

Transfer SQL Server Objects Task gives error with SQL Server authentication

 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: < xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".“

 
Once I changed the authentication mode from SQL Server authentication to Windows Authentication for the connections to sql server 2000 and sql server 2005 in connections manager, the package got executed successfully.

Can anyone tell me why the package was giving this error with the SQL Server authentication, while works fine with windows authentication



Answer this question

Transfer SQL Server Objects Task gives error with SQL Server authentication

  • Kelvin Penus

    Did you specify a login name and password for SQL authentication

  • Transfer SQL Server Objects Task gives error with SQL Server authentication
Answer this question