Hi, Can some body explain how could we counfigure the bulk insert Task in the SSIS package.We have have the data in the below format Example: "1"~"2"~"3"~"4" Note:We want to insert only 1,2,3and 4 in the data base.I have tried configure the same with the RowDelimiter as {CR}-{LF} and Column Delimiter as ~.But it is inserting the data as "1","2","3" and "4". Can some one has any thought on this?Thanks Chandan

While configuring the flat file connection manager put double quote (") as text qualifier.Nitesh Rai- Please mark the post as answered if it answers your question

Hi Nitesh,' We are not using FlatFile connection manager. Is it not possible to do with BulkInsert task?Do we have any thing like text qualifier in BulkInsert task? Thanks ChandanThanks Chandan

What is the source in your case?Nitesh Rai- Please mark the post as answered if it answers your question

Hi Nitesh Source is text file(.txt) Thanks Chandan

We are not using FlatFile connection manager.Is it not possible to do with BulkInsert task?Do we have any thing like text qualifier in BulkInsert task? Following is As-Is from http://msdn.microsoft.com/en-us/library/ms141239.aspx The Bulk Insert task can transfer data only from a text file into a SQL Server table or view. To use the Bulk Insert task to transfer data from other database management systems (DBMSs), you must export the data from the source to a text file and then import the data from the text file into a SQL Server table or view.Nitesh Rai- Please mark the post as answered if it answers your question

Okay. I found that Bulk Insert does not obey the text qualifier settings. So you are left with some options: Usa a data flow task Load the data with qualifieres and then remove them from the table by writing t-sql code using replace function.. Data flow task would be better option.Nitesh Rai- Please mark the post as answered if it answers your question