Hi, I created flat file connection manager with column names in the first data row because sample data file contained headers.
Real data files contain only data, no column names in the first row. When I uncheck 'Column names in the first data row' checkbox in the Flat File Connection Manager Editor, it tries to rename columns to Column 0, Column 1, etc, and complains that columns are out of synchronization.
I can enter column names manually in the editor but wondering if there is better way.
Thank you in advance.