zapallina (10/25/2012)
This is my first post ever so yea herewe go... let me say thanks for such an amazing and complete step by step post.I just came across with this email in my mailbox, just when it is almost time for me to develop a solution like the one you posted. My doubts and limitations rise when im stopped for that medium-sized wall called c#, so i need to keep practicing.
But i also have to achieve this using SSIS 2008 R2. So my question is, is it still possible?
Cheers.
Thank you for your kind comments. SSIS 2008 R2 uses a different version of the .NET Framework than does SSIS 2012 and while I have only tested this on SSIS 2012, to my knowledge I am not doing anything in the C# code that would prevent the technique from working for SSIS 2008 R2. That said, the C# Script Task development environment is a bit different in SSIS 2008 R2 so you may not be able to copy and paste the entire block of code from the article and paste into a SSIS 2008 R2 Script Task development window. You may need to be precise and only take the using statements you need plus the individual methods to fit them into the SSIS 2008 R2 Script task structure.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato