execution failed login task.

• srimkumarp

  Old Hand

  Points: 359

  More actions

  November 25, 2007 at 10:58 pm

  #121128

  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

• Powichrowski Marek

  Hall of Fame

  Points: 3483

  More actions

  November 26, 2007 at 3:59 am

  #753920

  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.