Sample Header Ad - 728x90

Data Flow Transform Not Automatically Mapping Columns

2 votes
2 answers
11450 views
I'm in the midst of creating a set of SSIS 2014 packages (using Visual Studio 2013) importing data from 50 tables. Since most of the tables are being filtered on the same column and I'm importing all columns into my staging area, I opted for a reusable design where my package name matches the table name, my OLE DB source query is defined with an expression-based variable (starting with SELECT * FROM ...) and my OLE DB destination table is also defined with an expression-based variable (in this case *schema.tablename*). Both the source query and target table have matching column names and match in most cases on data types and sizes. As I'm cloning my packages for each table, I copy/paste a previously-created package and visually inspect the mappings to confirm the expressions and the data flow mappings are valid for the new package name. I'm seeing that the expressions are working as planned, but I have to manually do the drag/drop mapping of most columns in the destination editor. Is this expected behavior of the editor as the design metadata of the original package is invalid under the new package name and is there a way to have Visual Studio delete and remap all columns in the data flow based on column name?
Asked by MattyZDBA (1955 rep)
Sep 29, 2015, 10:07 PM
Last activity: Jul 16, 2016, 07:31 PM