SQL Server Performance

DTS packages Error = -2147467259 (80004005)

Discussion in 'SQL Server DTS-Related Questions' started by vveeraneni, Apr 6, 2007.

  1. vveeraneni New Member

    Hello experts,<br /><br />I scheduled different DTS packages (through jobs) and getting the following errors.<br /><br />Job 1<br />Executed as user: NANsqlservmin. ...nStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3935 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3935 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Error at Destination for Row number 1. Errors encountered so far in this task: 1. Error source: DTS Data Pump Help file: Help context: 0 Error Detail Recor... Process Exit Code 1. The step failed.<br /><br />Jobs2<br />Executed as user: NANsqlservmin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147213304 (8004200<img src='/community/emoticons/emotion-11.gif' alt='8)' /> Error string: Column name 'ATTY_PAID_DATE' was not found. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 Error Detail Records: Error: -2147213304 (8004200<img src='/community/emoticons/emotion-11.gif' alt='8)' />; Provider Error: 0 (0) Error string: Column name 'ATTY_PAID_DATE' was not found. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun: Package execution complete. Process Exit Code 1. The step failed.<br /><br />We are running SQL 2000 and SP 2040<br />Please suggest me to run successful.<br /><br />Thanks,<br />Ven<br />vveeraneni@nan.net<br /><br /><br />
  2. MohammedU New Member

    Add the exception file to the dts package and see what is the eror for job1.
    Where as Job2 it says "Column name 'ATTY_PAID_DATE' was not found." so make sure columns are mapped correctly...

    I moving this to sql 2000...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. Olu New Member

    not very explicit the errors for job 1, however it appears there may be some anomalies with the schema of the destination table within the dtspump_task. however for job 2 I think you need to look at the table definition, it would appear to have changed since the dts task was created, and I suggest checking your dtspumptask_1 and remove the transformation for the ATTY_PAID_DATE column as it appears that DTS is trying to insert records into a column which does not exist

    Olu Adedeji

Share This Page