Microsoft has provided a sample component, UnpackDecimal, that is designed to unpack packed decimals coming from the mainframe (or other source, I suppose).
Many people want this feature in their Data Flows, but lack a full installation of Visual Studio (C#) to build the Microsoft provided solution. A build is required to obtain the .DLL file, which is necessary to have the component available to SSIS.
I’ve taken the liberty to compile this component for you, and have redistributed the full kit from Microsoft along with the resulting .DLL file. Instructions are also provided and are found in the INSTALL.TXT file.
Please note that the included README.TXT file is from Microsoft and should be read to understand how to setup the component when designing your data flows.
Also note that I don’t believe there are any error ouputs built into this component. That was left to the “student” to add before building the solution. I didn’t take the time to do so. You’ve been warned!
You can find the zip file here: http://www.ssistalk.com/UnpackDecimal.zip
You may also find this conversation over at the MSDN SSIS Forum of interest as well: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2373801&SiteID=1&mode=1