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.