Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Adding a column to a table at import (run) time. Expand / Collapse
Posted Friday, January 6, 2012 7:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 29, 2012 7:00 AM
Points: 37, Visits: 133
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.


Post #1231444
Posted Thursday, January 12, 2012 7:48 AM



Group: General Forum Members
Last Login: 2 days ago @ 8:10 AM
Points: 10,808, Visits: 14,835
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1234830
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse