Hi,

im trying to create a DTS in the SSIS.
I need to import an ASCII file to a table.
the problem is that I cant seem to import an ascii file which his rows has different size.
the flat file columns are ; delimited.

how can i do it ?

Thank you
Yuval

__________________
Yuval Kronenfeld
Israel

In SSIS, click data flow tab then select flat file source from the data flow sources

Jaime E. Maccou

Hi Jaime ,

I used that.
the flat file source know how to handle comma delimaited files but only when the rows size is identical (meaning all rows has equal number of columns).
I have in the first row for example 10 columns and in the next rows 20 columns.
SSIS cant handle it as much as I tried.

any ideas ?

can you share the file contents or sample to evaluate your situation?


Jaime E. Maccou

SSIS Flat File connection manager is expecting an equal number of columns in each line.

With the high level description you provided, you will need to either preprocess or post process the file.
Pre Process... Make all the rows uniform.
Post process... Change the connection manager to import each row as one string (i.e. set the column delimeter to {CR}{LF} and adjust the column width to a large enough size not to truncate any given row.) Depending on the row of data, you can then transform the row using a Derive Column or Script Component. Or, you could import the file into a stage table and T-SQL/.NET transform the row.

Good Luck!


Adam Gossage
Lake Wylie, SC, USA

Hi Adam,

Thank you.
You actually told me what I was afraid to hear.
I hate it when microsoft release a new version which has downgrades compare to the old version.
in sql 2000 it was so easy...:)

Thank you,

Yuval