scheduled "transfer login" task error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

scheduled "transfer login" task error

Author

Topic

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-01-04 : 13:57:56

Does anyone know why my scheduled task to transfer logins is failing? The DTS package also fails w/ unspecified error when executed manually. Below is the error from the job history but I don't find it very helpful. All the DTS package contains is the "transfer logins" task for 2 databases. Thanks. - ray

Executed as user: INTERCARE\sqlservice. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_OMWCustomTasks.OMWTransferLogins_1 DTSRun OnError: DTSStep_OMWCustomTasks.OMWTransferLogins_1, Error = -2147467259 (80004005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 700 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 700 DTSRun OnFinish: DTSStep_OMWCustomTasks.OMWTransferLogins_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-04 : 14:30:32

I can't help you with the DTS package, but I can help you with an alternative solution to transfer logins. Search the forums for isp_Transfer_Logins. It's a stored procedure that I wrote to transfer logins between two SQL Servers. It uses linked servers. If the login already exists on the destination server, it drops it and recreates it so that we know the passwords are in sync.

Tara