While it seems that there is a perfectly good variable waiting for you to access ("System::TaskName") (which I can see in my Variables window), this seems not to be available...

Great, thanks for posting back.

Thanks mate. Nearly beer time.

Create an integer...

Hmm, risky recommendation. Not sure I could solve this one using my iPod 🙂

Looks like everything worked OK apart from Send Mail - and that failed only because of a missing addressee?

At what point does it fail? Which component fails, I mean?

Please post the text of the error message.

I think you mean SSIS package, rather than DTS, but please confirm.

Are you...

That doesn't look like it will be very easy.

I'm interested to see what happens with white visitors 😀

Are you using a flat file source?

You need to go into the Expressions section for the flat file source and set the file name/path to your file-path variable using an...

Sounds like you might be looking for the SSIS equivalent of T-SQL MERGE, is that right?

What version of SQL Server are you using?

Please read Lowell's post.

I don't think it should be that messy - depending on your coding skills, of course 🙂

For each table in [array]

create destination table

copy data across

Next

Simple:-D

The data flow component does not work well in dynamic situations: you need to find another way.

One is the use of dynamic SQL to do all of the DDL and...

Brings to mind a whole batch of accountants doing multi-tab analyses very very slowly...