There are some good examples of this on SQLDTS.com

See http://www.sqldts.com/default.aspx?214 for some sample code.

Here's a relatively simple version :

1. Find the file name. The easiest way to do this is to write a stored procedure and return the filename to a Global Variable.

You...