I am importing csv file into sql server using ssis package. I have one text data type column in that csv file. I configured the source with necessary options, but i am getting the following error for the "text" data type column. Please help me asap. Thanks in advance. *************************************************************** Error: 0xC0202055 at Data flow task, Flat File Source : The column delimiter for column "column name" was not found. Error: 0xC0202092 at Data flow task, Flat File Source : An error occurred while processing file "**.csv" on data row 1336. Error: 0xC0047038 at Data flow task, DTS.Pipeline: 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. Error: 0xC0047021 at Data flow task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038. Error: 0xC0047039 at Data flow task, DTS.Pipeline: 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. Error: 0xC0047021 at Data flow task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039. Sateesh Maduri

How about using SSIS Import/Export Wizard? With the Wizard, you can see (view) that the source information is configured correctly.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Hello, I am not a specialist for SISS, but i suggest you to have a look on the line 1336 ( 1st line = 0) of the **.csv,you should have a problem with it. Maybe, you have in your .csv a byte equals to this used to delimite a data column or a record Have a nice dayMark Post as helpful if it provides any help.Otherwise,leave it as it is.

I verified the line 1336 in CSV file, all the data is delimited by comma. The data looking goods. And Using import\export wizard also its saying same thing. Please help me as soon as possible.Sateesh Maduri

I have embedded double quotes in one of the column in CSV file, and my text qualifier is "(double quote). how to configure that while exporting flat file data.Sateesh Maduri

Hmmm, try put "" to the text qualifiler in Flat file connection managerBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I have embedded double quotes in one of columns of my CSV file. E.g (see 2nd line) "Sateesh","Maduri",1,M "S""Folk", "M",1,M And as we dont have direct configuration properties for this type of flat files while importing into sql server, I have used the example given in http://www.ideaexcursion.com/2008/11/12/handling-embedded-text-qualifiers/ , but I am getting the error "value of type string cannot be converted to Microsoft.SqlServer.Dts.Pipeline.BlobColumn'. I have one column as Text column which have embedded double quotes in it. Please help me as soon as possible.Sateesh Maduri

Check out the following thread. Let us know if helpful. http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a1cea026-545d-4548-9358-97a56fca90f2 Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Do you have any regular expression to split this kind of CSV data(embedded quotes and commas in columns)Sateesh Maduri

The following page has a number of user-defined splitter functions: http://www.sqlusa.com/bestpractices/training/scripts/userdefinedfunction/ Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training