• For the deletion of the files you could also use a Script Task. I find it to be more useful than the File system task in some cases.

    If you wanted to get real tricky, you could do most of that stuff via Script tasks (delete the files, execute stored procs or adhoc queries and send mail) you'd just have to be a bit more adept at the programmatic means rather than the GUI. 😀

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events