You can use a Script Task with the following code. When you set up the task you need to define two outputs and columns, then set the ID...

If you have several columns you can also use the "Script Component' and regular expression patterns. I provide a video and sample code to do this at http://www.jumpstarttv.com/Media.aspx?vid=72.

You need to add the dll to the C:\WINDOWS\Microsoft.NET\Framework\v2.0.?????.

Also see

http://www.developer.com/net/net/article.php/3572761

Another approach would be the "Script Component". If you are more comfortable with coding you can use the following code for the string to decimal conversion.  You must set up...

You can do the first lookup and pass thru all columns then do the second lookup. This will cause all lookup to occur in the pipeline in lieu of SQL....