Thanks G, as always a font of knowlege.

I feared that would be your answer 🙁

Because I have about 40 tables to import and I already have the format files built and the only problem is the date format, I have elected to convert my script to a stored procedure and generate dynamic SQL. It's not pretty and I'm not pround of it, but it does work.

The SSIS is now going to look like

Set some variables

Execute SQL task: SQL from Variable (picks up the task name as the file to be processed)

Execute SQL task: SQL from Variable (picks up the task name as the file to be processed)

...

Execute SQL task: SQL from Variable (picks up the task name as the file to be processed)

Not very elegant.