May 13, 2006 at 11:28 pm
Hi,
i hav a text file in this format..
currency,exchangerate(INR),date
dollar,45,20/04/2006
dollar,46,22/04/2006
britishpound,65,20/04/06
dirham,12,20/04/06..etc..
now,i want that using this as source.. 2 tables should be created and filled with appropriate data..
CurrencyMaster..Currencyid(PK),Currencyname
CurrencyDailyRate..ID,Currencyid(FK),rate,date
how can i do it using SSIS?
thks
May 15, 2006 at 8:46 am
1. Use a multicast to split into 2 data paths
2. In first data path, use a SORT to get the distinct list of currencies. Push that data into CurrencyMaster
3. Push the second data path into a raw file.
4. In a second data-flow, take the contents of the raw file as input.
5. Use a LOOKUP component to get the CurrencyID from CurrencyMaster
6. Push the results into CurrencyDailyRate.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply