March 4, 2015 at 12:45 pm
Hi, I am new to SSIS, I have a table that I would like to capture daily currency conversion rates. In my Control Flow pane, I've been able to use a web service task to get a string value of the conversion rate pass it to an XML task, and connect it to at Data Flow Task. So now I'm not sure what to do from here. I would like to input the daily values into my table:
[CurrencyID] [int] IDENTITY(1,1) NOT NULL,
[CurrXDate] [datetime] NOT NULL,
[Country] [nvarchar](50) NOT NULL,
[CurrXRate] [float] NOT NULL,
insert into tbl_CurrXrates
(CurrXDate, Country, CurrXRate)
values
(getdate(), 'USD', @[User::ConversionRate])
What data tasks and order would I use to add a new row to my table which I think would be a simple insert statement. Hope my question makes sense.
March 4, 2015 at 12:53 pm
Are you only inserting a single row that is just values stored in package variables?
James Phillips
Sr. Consultant
Pragmatic Works
March 4, 2015 at 1:04 pm
jphillips 46546 (3/4/2015)
Are you only inserting a single row that is just values stored in package variables?
Hi jphillips, it will be one row at a time. Each row will have the current date, country and a package variable which is the current day country rate.
March 4, 2015 at 1:08 pm
In that case I would change the script task to be a script source component in the data flow task. That way the output from the webservice would already be in the data flow and you can then just add a derived column task for the variable and finally put it in a destination table.
James Phillips
Sr. Consultant
Pragmatic Works
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply