November 25, 2007 at 10:58 pm
hi, while copying logins from old sql server 2005 to new another server 2005
the below code displays errors msg . total logins 1350
SSIS package "Package.dtsx" starting.
Error: 0xC002F325 at Transfer Logins Task, Transfer Logins Task: Execution failed with the following error: "An exception occurred while executing a Transact-SQL statement or batch.".
Error: 0xC002F325 at Transfer Logins Task, Transfer Logins Task: Execution failed with the following error: "The database 'Automation' does not exist. Use sp_helpdb to show available databases.".
Task failed: Transfer Logins Task
Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (2) 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 "Package.dtsx" finished: Failure.
pls help some 1........
thanks
November 26, 2007 at 3:59 am
Verify that this database is accessed used connection attached to this task. May this database uses another database schema than dbo or is accessed as linked via linked server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply