How to deal with variable columns flat file

[satish_valavala]

Hi,

I have a comma delimited flat file with variable columns (not sure about the number of columns in each record, i.e., each record may atleast have 90 columns or more). I have to extract the file and use first 90 columns for our process. We may require rest of the columns for future process.

I appreciate any help on this.

Thanks
VS

[chulett]

Define the first 90 columns and enable the 'Ignore truncation warnings' option.

[kumar_s]

And mentioned the last column as a single Varchar(255). Which could include the rest of all columns.

[satish_valavala]

Thanks all