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-02-28 : 23:52:07
|
Teri writes "Using SQL 7.0 sp2- Created a DTS package that deletes the data in the tables for Server B before it copies data from Server A to Server B. Created as the server Admin. I can execute this package in DTS and it completes successfully. However, when it runs when scheduled, it fails. This is the error:
... DTSRun: Executing... DTSRun OnStart: Delete from Table [USMA_BDS].[dbo].[tbl_station_general_new] Step DTSRun OnFinish: Delete from Table [USMA_BDS].[dbo].[tbl_station_general_new] Step DTSRun OnStart: Copy Data from tbl_station_general_new to [USMA_BDS].[dbo].[tbl_station_general_new] Step DTSRun OnError: Copy Data from tbl_station_general_new to [USMA_BDS].[dbo].[tbl_station_general_new] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 1326 (52E) Error string: Client unable to esta... Process Exit Code 30. The step failed.
In the past when we received this error, we believe it to be an issue with having created it thru SQL Server Enterprise Manager (thus our local account is the owner) and not as the Server Admin. But, this did not work this time. I would appreciate any help with this matter. Thank you!" |
|
|
|
|
|
Scheduled DTS package Fails