Hi, I am loading pipe-delimited file into the database table.
The file contains only data, first row doesn't have column names. Database table columns match the datafile columns.
I'd like to match SSIS package 'Flat File Source - Output Columns' names to the db table columns. Now flat file source columns names are 'Column 0', 'Column 1', ...
I want to replace those values with real names (table column names).
Thank you for your help.