DTS Error

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  June 30, 2006 at 3:50 pm

  #67558

  I have this error mesg, not sure where the errror is, pls help. Urgent.

   

  Executed as user: CWOPA\OBSVCSQL01. ...Production\Jobs\FileTransfers     C:\Program Files\Common Files\System\Mapi\1033\NT>rename E:\Production\Jobs\FileTransfers\Inputs\ACCTG-TRANS ACCTG_TRANS.txt     C:\Program Files\Common Files\System\Mapi\1033\NT>rename E:\Production\Jobs\FileTransfers\Inputs\ARRHDR ARRHDR.txt  C:\Program Files\Common Files\System\Mapi\1033\NT>cd E:\Production\Jobs\FileTransfers\Inputs     C:\Program Files\Common Files\System\Mapi\1033\NT>del E:\Production\Jobs\FileTransfers\Inputs\ACCTG_TRANS.txt     C:\Program Files\Common Files\System\Mapi\1033\NT>del E:\Production\Jobs\FileTransfers\Inputs\ARRHDR.txtDTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSFTPTask_1   DTSRun OnFinish:  DTSStep_DTSFTPTask_1   DTSRun OnStart:  DTSStep_DTSCreateProcessTask_2   DTSRun OnFinish:  DTSStep_DTSCreateProcessTask_2   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnError:  DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (8004...  Process Exit Code 1.  The step failed.

   

   

• July 3, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  July 3, 2006 at 8:41 am

  #647238

  Have you set the task that is failing to run on the Main Package Thread?  I have seen this error thrown before and the solution I'd found on the web said somehing about DTS not handling activeX threads just right and to set it on the main package thread to correct the issue. 

  Also since this seems to be caused by one of your execute SQL tasks make sure your connection is set up correctly and whatnot.  If you are connecting to another database server you may want to check your driver conformance levels as well.  I once found an issue like this was caused by using an older PostgreSQL driver.  Once I changed that everything was fine.

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]

• ZenDada

  SSCarpal Tunnel

  Points: 4637

  More actions

  July 5, 2006 at 2:44 pm

  #647619

  Go back to your dts package in design view.  Right click in the design window.  Select Package Properties, the logging tab, and then have the package execution log to your sql server.  When the job fails, right click on the DTS PACKAGE and select package logs.  You will see the details of your error there.  That might be more helpful.

  [font="Courier New"]ZenDada[/font]