lundi 23 février 2015

SSIS Import Data and insert data


I have a situation in which i need to import data from one table to another. The challenge here is in tables i have some columns which references to other table values (kind of foreign key). What i need to do is I need to match these referencing column and if fields matches i need to map the respective id otherwise i need to insert that value in the referencing table and than map id in the source table data source and import all the data.


Could you please suggest me how to proceed for the following?


Elaborating my problem: ETL with Lookups


So this is how my ETL look like. Currently i am "On Lookup Match" moving forward with execution but I also need to create new records in the respective table if "Look up dont match".(and this i need to do for all the 8 lookup's i am doing). I do not understand how to do all this in sequence and import all the data at final stage.


I am stuck at this please help how shall i proceed.





Aucun commentaire:

Enregistrer un commentaire