Get the value from destination db table

Question

Hi,

I have a below requiremnt. Please suggest me how to do this.

From source(Oracle), I am getting three columns data and I have to insert this data into destination table. Two columns i have mapped diectly. Upto here no issue.
Think that my third column is country name and in the destination I have to insert the countryid instead of country name. Country master table is in destination db.How can I get the country id using the country name and how to insert this into my destination table along with other two columns.

Thanks
Ramesh D

Answer 1

Hi Ramesh - You should be able to use a lookup component for mapping country name to country id in your data flow.

Answer 2

Thanks for your response.

How will I use the lookup here? If country name is there, I have to get the country id otherwise null value I have to set. After this which condition I have to select like matched output/no match out put.

Thanks

Ramesh D

Answer 3

If you're not familiar with the lookup component, you may want to follow the guidance at http://www.katieandemil.com/ssis-lookup-transformation-example-sql-server.  If you need country id or null, it sounds like you could use "Ignore Failure" for how to handle rows with no matching entries.