Thanks for the help.  I would like a little clarification, if possible. 

"What I would suggest is setting the SQL for the ExecuteSQL tasks using an ActiveX script."

I am currently...

I have a similar situation.  Several times a year I have been manually creating separate tables for each of my text files located in directories.  Each text file is created...