January 6, 2012 at 7:09 am
I have an SSIS package that I used to import excel data, I need to add a column to the table when I import the data, however, the column, is contrived data joined from another table that already exists in the sql server database.
Does anybody know how I would even begin to do this?
I've tried "derived column" however, the data that populates the column is not derived from the source excel data, rather, a join from the data to that other table.
Thanks
😛
January 12, 2012 at 7:48 am
Sounds like you need to use the Lookup Component. The Lookup Component is like a JOIN in SSIS. You define the source of the lookup and the column(s) to join on. For example, if you are importing order details and the orders already exists you would add a Lookup Component to your data flow with a source of the orders table, your join would be on the order number column and you would return the order id column to the data flow.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply