Unlike SQL Server 2000 DTS, SSIS Flat File Connection Manager Editor does not provide available list of Text qualifier,

i tried

-- ""

-- double quote {"}

-- "

--{"}

but none of them worked....!

My file sample looks like this

"Col1","Col2"

"1234","3456"

"3456","1234"

what qualifier should I use then?

Many Thanks,

It appears that double quote is the qualifier.

However, manually you should remove double quotes in the header row.

It appears that double quote is the qualifier.

However, manually you should remove double quotes in the header row.

You are right. The text qualifier will be ".

I don't think you need to remove double quotes from the header row. It works fine in SSIS 2008. I just tried it.

Thanks,

Ritu

I am using 2005, and it simply does not work, it is taking " as part of data. and will not process it.
also, you can type anything in that box (text qualifer), there is no validation.

in 2000, we have list to choose from. Why Microsoft is going backward.....!

thanks,

Can you post a subset (20 lines) of your file so we can test it?

Make sure that the data type of the columns is DT_STR or DT_WSTR - since it is a text qualifier, the column must be a text type. Also, you should only put a single " in the box, not two ("").

Can I have multiple Text Qualifiers ????