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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-28 : 09:14:42
|
| Gregory writes "I have a DTS setup that copies a couple of databases from one server to another in order to have a hot backup server. When I execute the DTS package from the DTS portion of the Enterprise Manager tree it runs fine. When I schedule it, it fails with the following error:DTSRun OnStart: DTSStep_OMWCustomTasks.OMWTransferLogins_1DTSRun 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: 700I cannot find anywhere where this error is explained or even referenced. Any help would be greatly appreciated." |
|
|
Kevin
Starting Member
3 Posts |
Posted - 2001-11-29 : 13:37:59
|
| Hey Gregory, reading your message is deja vu -- I know EXACTLY what you need to do! I spent forever with this same problem, I know those error numbers are nowhere to be found. It was only through starting from scratch and going through the whole setup over that it hit me. Your ODBC driver needs to be set up using a System DSN, not a User DSN. As a User DSN, your driver is not visible to your SQL Server Agent startup account, which handles the scheduling.HTHKevin |
 |
|
|
|
|
|
DTS woes