July 10, 2006 at 11:06 am
When copying data between a SQL2K source and a SQL2K5 destination, both using mixed sql server security mode, my job generates the following error:
[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".
This occurs after the destination database tables have been truncated and replacement data from the source would begin to copy.
The same process can be successfully completed from the Management studio with a simple data export process. However, when I run the saved package again from the BI interface, I get this error.
My search engine searches have yielded numerous hits of others having the same problem with one microsoft rep indicating it was a bug and would be resolved in sp1. I am working with sp1. Oddly, there is only mention of this in the forums. No KB article from MS addresses the problem and I do not see it addressed elsewhere at sqlservercentral.
Does anyone have any information concerning this problem?
July 13, 2006 at 8:00 am
This was removed by the editor as SPAM
July 13, 2006 at 8:10 am
Are you using configuration files? If so, do you connect using SQL authentications, and if so, is there any chance the configuration file is missing the login name?
July 13, 2006 at 8:31 am
I am not using configuration files and I am mixed mode security. The problem, which I can duplicate with the most trivial example, has been logged previously by an MS person in the community form, but curiously was marked as resolved prior to the release of SP1. I expected a solution to show up in the service pack, but all evidence suggests otherwise.
The problem is limited to mixed mode security, but because I am transferring data from my network to a hosted server outside my domain, so I must continue to use mixed mode security with a sql server login.
Search on this string and you will see many posts, but no solutions.
"Cannot apply value null to property Login"
Thanks for your reply.
Rick
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply