DSXchange

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

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

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

Thanks all