Really need help w/ Connection Manager in SSIS 1

[sqlsadie108]

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","INFYSW ","L","Z98ZVL97R","2006-06-02"

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

My settings are:
Format: Delimited
Text Qualifer: Double Quotes {""}
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"

It's concatenating everything after column 1 as one column, which is NOT what I want.

I really need help here.

THANKS

 

[mrdenny]

That's not a properly formatted file because the number of columns aren't static across all rows. It will be very hard to get this imported.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sqlsadie108]

duh, yes I see now that in the original DTS pkg it is skipping the first row!

I am glad I am not crazy here