July 15, 2011 at 4:58 pm
Pulling Data from the AS400 table. But i get this error after loading some where at 240,000 row. I tried with data conversion component. But it like failing to export from the table to Data conversion task it self. As i have no idea, what its trying to say ... can anyone help
error: 0xC02020A1 at AS400 to Flat file, fck [2868]: Data conversion failed. The data conversion for column "a" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."
Error: 0xC02020A0 at AS400 to Flat file , fck [2868]: Cannot copy or convert flat file data for column "a".
Error: 0xC0047022 at AS400 to flat file, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "fck" (2868) failed with error code 0xC02020A0 while processing input "Flat File Destination Input" (2869). 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.
Error: 0xC02090F5 at AS400 to flat file, AS400 [1]: The component "AS400" (1) was unable to process the data. Exception from HRESULT: 0xC0047020
Error: 0xC0047038 at AS400 to flat file, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "AS400" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
July 16, 2011 at 8:20 pm
What is in the 240,000 row? Bad Data...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 18, 2011 at 8:24 am
Thats the problem ....made a error output flatfile after the data conversion component, but as the cloumn is not been exported from the source itself, its difficult to say. But according to error, there is mismatch from the codepage, I think.
July 18, 2011 at 8:36 am
quillis131 (7/18/2011)
Thats the problem ....made a error output flatfile after the data conversion component, but as the cloumn is not been exported from the source itself, its difficult to say. But according to error, there is mismatch from the codepage, I think.
What are you using as your column delimiter in your flat file extract?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 18, 2011 at 3:17 pm
comma(,)
July 18, 2011 at 3:23 pm
quillis131 (7/18/2011)
comma(,)
You don't want to use a comma. If there is a comma in any of your columns your transformation will fail.
Try using a pipe | or some ASCII Code that someone will ever enter in the AS400 Database.
There may be other issues but give this a shot.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply