February 22, 2008 at 7:55 am
I'm trying to create a simple Transfer Logins Task in SSIS.
I've got two SQL 2005 Standard Edition servers. I've copied across a database from server1 to server2 (backup / restore). I now want to use a Transfer Logins Task to bring across the logins for that database. This is a test for our Log Shipping setup, the plan being to run the task once a week to bring across any newly created users.
The task is configured as follows :
SourceConnection : Server1.sa
DestinationConnection : Server2.sa
Logins to transfer : AllLoginsFromSelectedDatabase
DatabaseList : DB123
If Object Exists : Skip
CopySids : Yes
I then save a copy of this as a package on Server1 and execute the following command from within SSMS :
EXEC xp_cmdshell 'dtexec /sq package /ser server1'
When I do this, no logins are transferred, and I get the following error :
Description: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".
Can anyone advise me as to why I should be getting these errors?
February 22, 2008 at 9:32 am
By using Windows authentication, instead of SQL, I no longer get the error.
The transfer will now run, provided I opt to transfer all logins. If I try and specify All Logins for a Specific Database, then although it will run without errors, it does not actually transfer any logins at all.
Anyone know what I'm doing wrong now?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply