No problem. There is very limited documentation around to explain which variables are 'hidden' and which are not.

If you set...

Quote from Technet about IDTSVariables100:

See here.

Also, the system variable you have accessed is...

Anjan Wahwar (3/13/2011)

---

Hi lrutkowski

The way you are writing the script will work fine with SSIS 2008, though in your case i would rather suggest to use Script Task. You...

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.