March 24, 2015 at 1:41 pm
Hi, I'm a little lost (and new) on where to begin with this. Using SSIS 2008 r2 I've been able to create a small package to connect to a currency converter web service and select the hardcoded supplied by a web service. However, doing it this way I would have to create multiple mini sequence containers and select the currency to and from country codes. I would like to create a user::to and user::from variable and then run a sql task to set the variables.
Ie, select distinct( [to_countryCD], [from_CountryCD] ) from tbl_CountryCd
and then run my sequence as a forloop dynamically passing the 'to' and 'from' country codes. Any idea's would really be appreciated.
March 30, 2015 at 9:14 am
Marcus Farrugia (3/24/2015)
Hi, I'm a little lost (and new) on where to begin with this. Using SSIS 2008 r2 I've been able to create a small package to connect to a currency converter web service and select the hardcoded supplied by a web service. However, doing it this way I would have to create multiple mini sequence containers and select the currency to and from country codes. I would like to create a user::to and user::from variable and then run a sql task to set the variables.Ie, select distinct( [to_countryCD], [from_CountryCD] ) from tbl_CountryCd
and then run my sequence as a forloop dynamically passing the 'to' and 'from' country codes. Any idea's would really be appreciated.
I am doing something similar, and in my scenario I have to pass a formatted url to extract the currency rates and save it as an xml file.
This is how I am currently doing it, and it works pretty well for me:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply