I have a dts job that moves data from mssql to our as400. When executing the dts package it runs fine and move the data with no errors. But when I make the package a job I get the following error:
Executed as user: PEPPERMILLCAS\rccds. …t: Copy Data from Results to “PEPPER”.“CMSCUSALL”.“F1042SIMPT” Step DTSRun OnError: Copy Data from Results to “PEPPER”.“CMSCUSALL”.“F1042SIMPT” Step, 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 Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Query cannot be updated because it contains no searchable columns to use as a key. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnError: Copy Data from Results to “PEPPER”.“CMSCUSALL”.“F1042SIMPT” Step, Error = -2147213206 (8004206A) Error string: The number of failing rows exceeds the maximum specified. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help f… Process Exit Code 1. The step failed.
Has any body else had this problem and able to fix it?
Thanks
