I have had a look at these and nothing really solved the issues in SSIS, I think I need to build this into SSIS, just not sure exactly what to use, I have downloaded some SSIS books but all the samples they work with are for importing multiple files into SQL. Do you have some links to videos or guides that will help with this specific case. It looks like I need to use The For each loop, a lot has changed from SQL 2008 where I last used SSIS, and it looks like there is a lot of really great things to use that will help me, I just need the basic logic that I should be using.
What exactly the issue you are facing write now? If you want to delete the data in bulk with performance then you SHOULD BE doing it on SQL SERVER even if you are using SSIS (e.g. Execute SQL Task). The other option is the row by row deletion from SSIS same like cursor.
Help me understand what issue you are facing against the solution shared earlier, Share some details?
Regarding SSIS basic understand you can look into the following:
Stairway to Integration Services Andy Leonard [/url]
that will get you on track of many things.