<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Jeff Singleton
»
Capturing Real-Time Currency Conversions in...
19 posts, Page 2 of 2
««
1
2
Capturing Real-Time Currency Conversions in SSIS
Rate Topic
Display Mode
Topic Options
Author
Message
SQLRNNR
SQLRNNR
Posted Thursday, April 29, 2010 1:41 PM
SSCoach
Group: General Forum Members
Last Login: Today @ 6:30 PM
Points: 18,733,
Visits: 12,330
Thanks for the article.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #913228
ava1over
ava1over
Posted Thursday, April 29, 2010 2:17 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, April 18, 2013 11:56 AM
Points: 27,
Visits: 113
richard.maw (4/29/2010)
There may be other motives for the method shown that I'm not getting but it seems to be an insanely inefficient and complicated way to do it: read service, write to file, read file, parse text, convert text, wrap it in dataset, iterate over dataset and then run the update. You can do it in two steps (1) read service into text variable (2) pass the text variable to the update statement. The parsing is done in SQL like this:
Update CurrencyConversion
Set USD_Amount = Amount * convert(xml,?).value('(//double)[1]','float'),
ConvertedDate = getdate()
Where USD_Amount IS NULL
Good point and very true. As with any exercise I wanted to show off some of the other capabilities that SSIS has... some for my benefit and hopefully for the benefit of a few others.
Post #913264
rmaw-1095848
rmaw-1095848
Posted Thursday, April 29, 2010 6:14 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, February 21, 2013 7:32 AM
Points: 2,
Visits: 27
Fair enough, I learned something myself. But if someone is just looking for the functionality provided the two-step method is the way to go.
Post #913335
nba.ahamed
nba.ahamed
Posted Sunday, May 02, 2010 6:15 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 03, 2012 1:52 AM
Points: 1,
Visits: 7
Hi,
Good articles, but it is not working for me
I got below error message in RecordSet Destination
Error at Data Flow Task [RecordSet Destination ..]: The type of the runtime variable "User:ExecutedConversion" is incorrect. The runtime variable type must be Object
please assists.
Bahru
Post #914349
sharath.chalamgari
sharath.chalamgari
Posted Monday, May 03, 2010 3:35 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038,
Visits: 679
For this Error please go the variable section and change the DataType to Object.
Post #914546
sharath.chalamgari
sharath.chalamgari
Posted Monday, May 03, 2010 3:38 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038,
Visits: 679
Hi All,
I have similar kind of requirement where i need to change the amount into the USD,but in my case the amount will be in different currency format say for some columns it is IND and for some column it is CAD.so how to go in this scenario.
Post #914548
ava1over
ava1over
Posted Monday, May 03, 2010 8:24 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, April 18, 2013 11:56 AM
Points: 27,
Visits: 113
You might have to do multiple calls into the web service based on the number of currency codes you are converting.
Post #914710
mudegv
mudegv
Posted Wednesday, May 12, 2010 2:13 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, March 02, 2011 1:22 AM
Points: 1,
Visits: 12
Hi,
This is a nice article. I am replacing the currect logic in my application to this one. It is throwing an error "Proxy authentication required" (refer the error below) do i need to add the proxy credentials? can anybody help please...
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: The request failed with HTTP status 407: Proxy Authentication Required.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
Post #920234
number7
number7
Posted Thursday, August 12, 2010 8:18 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2013 5:02 AM
Points: 2,
Visits: 88
Thanks for the Article Its just what I am looking for .
I cant get it to work though,I think its something to do with the variables .
And explicitly setting them from currency to string,I just dont have a clue how to do that though .
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object..
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
Post #968210
« Prev Topic
|
Next Topic »
19 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
