You might have to do multiple calls into the web service based on the number of currency codes you are converting.

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,...

Thanks for the feedback Bob. In regards to your question: it depends. Like Phil...

Hey John, thanks for the reply. This is really good data and to...

Hmm, that is an interesting question. I will have to do some trials of my own. I have been able to reuse a file just with a separate...

Good Question. For this file there were the same number of columns in all rows [43]. However, you have a few options for your scenario:

1) Have the connection...

Great question. Below is a link to a post that sheds a little more light on exclusion groups:

http://consultingblogs.emc.com/jamiethomson/archive/2008/01/05/SSIS_3A00_-ExclusionGroup.aspx

No need for 3rd party software; conversion of packed data using SSIS is explained along with a demonstration here: http://dataintegrity.wordpress.com/2009/10/02/ebcdic-packed-comp-3-data-ssis/

This blog describes how to do it.

http://dataintegrity.wordpress.com/2009/10/02/converting-dbf-files/