I have a dataflow that has a source of an Excel file and ending in a SQL data table. I need to change the source from Excel to a delimited file. Is there a shortcut I can use? This file has many fields I am trying to get around having to remap each field individually.
Date
Votes
1 comment
-
Mike O'Quinn There is no shortcut to replace sources. You will have to re-map the source. One trick I can give you is to use a passthrough transformation. Use the "insert" short-cut to insert a passthrough transformation between your source and SQL data table. To do this, drag from the toolbox the passthrough transformation and hover your mouse over the edge of the bolded node. When you do this it will light up red. Release the mouse button at this point and it should insert in between the Excel file and the SQL table. Make sure to insert on the Excel side. The reason for this is so that it copies the Excel layout and not the SQL one. This is assuming that the delimited source has the same layout as the Excel one. Now, at this point you can delete the Excel source and now auto-map the delimited source to the passthrough and since the layouts are identical, it should map in one go and you don't have to worry about re-mapping the SQL table.
Please sign in to leave a comment.