February 15, 2012 at 10:49 pm
I have a flat file that contains 10 lakhs records.While i am trying to import it into sql server table I am getting the following error.
[Flat File Source [1]] Error: The column data for column "LastName" overflowed the disk I/O buffer.
[Flat File Source [1]] Error: An error occurred while processing file "H:\EFax-SSIS\Medesign_Patients - Copy.txt" on data row 24768.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202092. 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.
I redirected the falt file source error out put to another flat file destination.
But its not redirecting the dirty records to error output.
I think there is no problem with the data.
Please help me in this regard.
Thanks,
Venkat
February 16, 2012 at 12:09 am
What is the encoding of the text file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 22, 2012 at 12:46 pm
It has something to do with your text file and the delimiters or CrLf.
In my case, I was expecting
Col0, Col1, Col2 <CrLf>
1, 2, 3 <CrLf>
etc....
When I opened the file up in NotePad, it looked like this.
Col0, Col1, Col21,2,3
Notice the Col2 and the 1 are smashed together.
When I open in Word Pad, it looks ok. So something is going on with how Notepad reads the file vs how Word Pad reads the file.
Essentially, you need to alter something in the file or the way the ssis reads the file
Look at using a different Header Row delimiter in your import, like CR rather than CRLF.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply