I am trying to load a delimited flat file with " as qualifier. We use SSIS 2008 and using attinuity connector for teradata destination.
The load seems to be running but in the end it fails with the below error and it doesn't commit any records :
[Teradata Destination ] Error: There was an ODBC error while trying to read error tables. Invalid TPT operator.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Teradata Destination" (698) failed with error code 0x80004005 while processing input "Teradata Destination Input" (721). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Can anyone suggest what can be reason for this. I tried to increase the error counts as well but it doesn't work.