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  Import/Export (DTS) and Replication (2000)  Newbie with DTS question for transfering db users

Author  Topic  kodedra Starting Member 1 Post Posted - 2005-02-16 : 06:33:01 Hi First post, Please could someone explain why i'm getting the error below, when trying to create a DTS package to transfer database users to a secondary server in a log ship enviroment from the primary server. Servers are in a workgroup environment. Log shipping is setup and working just need to create the procedures for role reversal. And now the error below, many thanks! 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.