November 11, 2004 at 6:34 pm
Hi,
I have a simple DTS which copies data from AS400 to SQLServer.
Connection to AS/400 is through ODBC client access driver.
This DTS works fine when run through Enterprise manager. But fails if run through a job. Gives out following error.
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, 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: 5 (5) Error string: Error source: Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Same DTS on another SQLServer on other machine works fine as a job.
SQL Server and Agent on both SQL Server machines are running under similar local userids with similar permissions.
Tried testing with different - odbc connections, client access connections, database, table, dts, AS400 profiles etc. No luck.
Another DTS doing similar work, has no such problem. But it connects to different AS400 box with different profile.
Please let me know if somebody knows whats happening. Please let me know in case more details are required about the problem.
Regards
Pavan HA
Pavan H A
November 15, 2004 at 8:00 am
This was removed by the editor as SPAM
November 22, 2005 at 4:04 am
I have the same problem. Copying data from a Unidata ERP system to SQL Server.
The DTS executes fine in Enterprise Manager but fails to run as a job.
I get the following error message
Executed as user: PILKINGTONS\Administrator. DTSRun: Loading... Process Exit Code 1. The step failed.
I thinik it's to do with permissions, but I have started SQLSERVER Agent as Administrator, created the Package as Administrator
and Run the job as administrator.
Any Ideas would be greatly appreciated.
simon
May 9, 2006 at 12:21 pm
I know it's very after the fact. Just in case anyone else has a similar issue: You can enable logging in the dts package design view and log to a text file. In my case, it was a bad date range that someone had entered. The log actually showed the offending record. HTH
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply