Flat file connection manager not parsing file correctly

Hi,

I have a flat file, comma-delimited, with strings in double-quotes.

In the connection manager for the file, I have specified that the Text Qualifier = ""

However, in the preview tab, it still shows the strings as surrounded by the quotes, e.g. "mycol1" whereas it should show mycol1 without the quotes.

Next, when I examine the data in the database after the load, it's messed up there also.

"mycol1" ends up in the database as "mycol1

"mycol2" ends up as "mycol2

This is not right.

I have format set to delimited, header row delimiter crlf, etc.

Any ideas?

Thanks

I sort of see what's happening.

The "mycol1 problem is due to the fact that I have mycol1 set as a string with a length of 6. Because it's not stripping off the double-quotes correctly, it counts the first six characters of "mycol1", which is of course "mycol1. It's counting the first double-quote as a character.

So the question remains, HOW do I get it to recognize the fact that "" are the text delimiters?

I remember setting up this same flat file connection before and it worked, but now it's not.

|||

Nevermind!

The text delimiter is ", not ""!!

doh

sql