Should be in SSIS Zone.
1. I have to insert data into a lookuplist table.
2. Lookuplist table, has all the lookup categories such Country(1000), State(1001), City(1002) and others.
Database is Sql server2005.
This is how the data looks on lookuplist.
UniqID LookupCatType lookupvalue lookupdescription
1 1000 USA United States of America
2 1000 JPN Japan
3 1000 CAN Canada
4 1001 NY New York
5 1001 MO Missouri
6 1001 IL Illinois
Let's say State/country exists on different tables in the source database & I have list.
1. I need to do either Union All or Merge or Merge Join to get all State values from different tables. Correct ?? I'm good till here..
2. How would i insert these States values to above tables, UniqID is Identity Insert so no problem there but LookupCatType needs to be 1001(manually).
a) Which component should i use especially has destination.
b) Can you send me small package if its simple or atleast send me some screen shots or put me on right track.
Note: I know how to do this using execute sql/script task but i'm trying to find out
if i can do this using data flow destination components.