17 September 2010 16:18
Unpack decimal for SSIS 2008
Microsoft released a component for SSIS 2005 to convert a packed decimal (comp 3 format) into a decimal so you can use it in a data flow. Details of it are at http://www.microsoft.com/downloads/en/details.aspx?familyid=0e4bba52-cc52-4d89-8590-cda297ff7fbd&displaylang=en
Unfortunately , this doesnt work in SSIS 2008, but with a few simple changes to use SSIS 2008 types rather than 2005 ones it does.
Here is the source code with these modifications and compiled dlls (in debug and release configurations)
Filed under: ssis unpackdecimal