HELP! SQL 2005 Integration Services - Transfer SQL Server Objects Task - Cant Connect Using SQL Server Authentication
Posted on 2006-11-07
I am using SQL 2005 Integrations Services and am copying data from my SQL 2005 database to a SQL 2000 database using the Transfer SQL Server Objects Task.
However, if I use windows authentication to connect to the 2000 database if works fine. If I use SQL Server Authentication I get the error: -
[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".
The process can see the database and logon as I get the message: -
[Transfer SQL Server Objects Task] Warning: Table "Internet_Brand_Links" already exists at destination.
But it somehow is messing up somehow along the way.
I am logging on using the SA username and password so it is not a permissions thing.