Restituisci
-
Titolo
Error During Batch Import Systems; DTSRun OnError: DTSStep_DTSExecuteSQLTask_3 -
Descrizione
When running an Import batch file on the appliance, an error is returned:
DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147220421 (8004043B)Error String: The task reported failure on execution.Error source: Microsoft Data Transformation Services (DTS) PackageError Detail Records:Error: -2147220421 (8004043B); Provider Error: 0 (0)Error String: The task reported failure on execution.Error source: Microsoft Data Transformation Services (DTS) PackageError: -2147217900 (8004E014); Provider Error: 170 (AA)Error string: Line 1: Incorrect syntax near ''.Error source: Microsoft OLE DB Provider for SQL ServerINFO: 54 Comma-delimited value(s), EOL=CR-LF, Column Headers -
Risoluzione
Please verify the formatting of the import file. Ensure there are no erroneous spaces or characters. The above example error was returned when there were extra spaces at the end of a numerical value on one line in the Import file.
If there are spaces at the end of a value and before the next comma this error may be returned.
When testing an Import file, it may be useful to test an Import file just one line to see if this is successful.
It may be useful to further narrow down the issue by running the Import file in portions; possibly the first half of the file is successful, and the second half fails. This method may help narrow down any specific issues.