ncubillos


Hi everyone

I¡¯m using the Flat File Connection Manager to access a flat file, tab delimited. The flat file has 200 columns, and when I'm editing the columns, I only preview columns from 0 to 97.

Does the flat file connection have a column number limit How could I increase it

Thank you for your answer.....

Regards,





Re: SSIS Flat File Connection Manager Max Columns

Jamie Thomson


I'm afraid I don't know. When you say there are 98 columns displayed, is that in the preview window

How many columns are defined on the 'Columns' tab of the Flat File Connection Manager

-Jamie







Re: SSIS Flat File Connection Manager Max Columns

Kaarthik Sivashanmugam

I dont think there is any known limit on the number of columns in FlatFileConnectionManager (apart from the theoretical limit which, I guess, could be the max value supported by int variable). 200 columns sounds too less to be that limit. I created a test file with 240 columns. In FlatFileConnectionManager editor I could see all the columns in "Columns", "Advanced" and "Preview" pages.






Re: SSIS Flat File Connection Manager Max Columns

Duane Douglas

Kaarthik Sivashanmugam wrote:
I created a test file with 240 columns.
How did you create this test file

Just curious.






Re: SSIS Flat File Connection Manager Max Columns

Rafael Salas

Duane Douglas wrote:

Kaarthik Sivashanmugam wrote:
I created a test file with 240 columns.
How did you create this test file

Just curious.

I just create mine using 'Save as' in excel






Re: SSIS Flat File Connection Manager Max Columns

Duane Douglas

Rafael Salas wrote:
Duane Douglas wrote:

Kaarthik Sivashanmugam wrote:
I created a test file with 240 columns.
How did you create this test file

Just curious.

I just create mine using 'Save as' in excel

Ok. But I was wondering if there is an automated way to create and populate the columns.




Re: SSIS Flat File Connection Manager Max Columns

joeydj

hi,

maybe the data on the nth row does not match the schema

where nth=98 or 99

or there's a schema violation such as datalength or data type

or the row is null with nothing there but cr & lf

regards,

joey