Really need help w/ connection manager problem in SSIS

Hello,

I am attempting to set up a Connection Manager for a Flat File Source.

Data in my flat file is like this, for example:

"038188306","03/02/2007"
"038C88328","9A9990846","INFY-SW ","L","Z98ZVL97R","2006-06-02"

Row 1 has two columns, Row 2 has six columns (as delimited by the double quotes).

Format: Delimited

Text Qualifer: {""}

Header Row Delimiter: {CR}{LF}

But when I click on the Columns button, it only shows 2 columns. For example, it shows the first row correctly, but Row 2 shows as:

Column 1

"038C88328"

Column 2

"9A9990846","INFY-SW ","L","Z98ZVL97R","2006-06-02"

which is NOT what I want.

I really need help here.

THANKS

Nevermind, figured it out :-)

Need to skip first row

|||

Hey K108,

I just wanted to know how did yo figured ti out.

Thanks,

Vikt

|||The answer is, all the rows in the text file must have the exact same number of columns. In my text file, the first row is garbage data with only 2 columns. So I just needed to select the option to skip 1 row.