Lowell, I have a select query that I use as the 'architectural plan' for my SSIS package. From this experience I have noticed that because the source of my SSIS package is an Excel spreadsheet, there are many idiosyncracies that I do not have to consider when I am writing a sql statement against a sql table, that I do have to consider (but currently am not good at :-)) when writing for excel.

I am learning how to troubleshoot excel based ssis flows.

Thank you for your help today.