Hi, In order to convert the packed fields, Microsoft has released Unpack Decimal transformation but it supports only SSIS 2005 version. I don't see a version that can support the SSIS 2008. Please let me know, as to how to handle these packed feilds using SSIS 2008. Regards, Tushar.

Hi, Based on my research, I also can't find UnpackDecimal for 2008. So could you try to open UnpackDecimal project with SSIS 2008 and upgrade it? Please feel free to let me know if I’ve misunderstood anything.Please remember to mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Has anyone successfully upgraded this? I've been working on it for 2 days & I'm not having a lot of success.

Oh, I think we just got it. Manually switched all the names that used "90" for 2005 (e.g. idtscomponentmetadata90) to "100" for 2008 & then re-compiled & it worked.

dethwsh - you are a genius. It worked !!!!!!!!!!!!!!!!!!!! Myself and others have been struggling with this for ages. This issue has been around for years, has been on many Microsoft Forums, and has been totally ignored by Microsoft. Now if we can just get someone to work out how to prevent the SSIS FTP Task from wanting the remote path to begin with a "/" then all the people who have to FTP from Mainframe MVS sources will be rapt. (using the command line FTP client is hopeless as timeouts can't be controlled) These have been my 2 biggest problems with 2008 BI (which I absolutely love after switching across from the Cognos camp). So Microsoft if you are listening it is very frustrating when we have 2 relatively simple issues causing so much grief and no attention is put to fixing them.

Great...!! Are those dlls available to download from somewhere? If not, Can someone post those DLLs? Sams

I just had to use this in SSIS 2008, so i have modified the source and uploaded it (along with compiled dlls). You can download it from my blog at http://sqlblogcasts.com/blogs/antxxxx/archive/2010/09/17/unpack-decimal-for-ssis-2008.aspx Anthony

I changed all the 90s to 100s and the code is fine, but signing the assembly giving me the following error "Error 1 The command "..\..\regcomponent UnpackDecimal" exited with code 1. UnpackDecimal". Did you have the same issue? If yes, how did you fix it?

1) make sure that the path to the gacutil.exe is in your DOS path environment variable - so the first two lines of regcomponent.cmd will work 2) make the directory named in the third line of regcomponent.cmd where you want the dll to end up. I had to make two changes for mine to work. From: C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents To: C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents