Yes sure.

You will find here all the component I use:

- Flat File Connection Manager (format:delimited; text qualifier: "; header row delimiter: {CR}{LF};

- Flat File Source;

- Data Conversion Transformation (used to transform all the string to Unicode String)

- Ole DB Destination Editor (used to insert the data in database)

The error following error appears directly in the Flat File Source.

Error: 0xC0202055 at DFT_LoadingExcelSheets, Flat File Source [1183]: The column delimiter for column "Billing End Date" was not found.

Error: 0xC0202092 at DFT_LoadingExcelSheets, Flat File Source [1183]: An error occurred while processing file "\\cfsdata01\vmnc\RAID\Data Upload\Sources\Eboat\file.csv" on data row 1441.

Error: 0xC0047038 at DFT_LoadingExcelSheets: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Connection" (1183) 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.

Error: 0xC0047021 at DFT_LoadingExcelSheets: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at DFT_LoadingExcelSheets: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at DFT_LoadingExcelSheets: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Information: 0x40043008 at DFT_LoadingExcelSheets, DTS.Pipeline: Post Execute phase is beginning.

The row content is:

"toto","tata","tata""toto"", OJSC","tata","tata","CB ""tata"", tat","tt","tata","tata","59595","0","tata","0","","tata","tata","1","1200","tata","1200","tata","20.50","N","","2010/05/26 00:00:00",""

I changed the text values with toto tata due to some confidential information. But the problem is that some noisy comma are part of text.

Hope this helps,

Regards,

Damien