SSIS Column Header Mapping
Posted on 2010-09-20
I am going to see if I can explain my situation without confusion. :o)
I set up a package to import flat files into an OLE db destination (SS table). These flat files that will be imported will have various column headers (and in any order) and I want to select ONLY those columns in the file that match the column header names in the table and then map them to the appropriate table column.
I tried a simple mapping directly from the flat file connection manager to the table and the data is not being imported into the proper columns, because the columns in the flat file are arranged in a different order.
Is there a component to search specific column header names and map only the data from those columns? Any ideas?