• That is definitely an option. The only thing I didn't like about that option is I'm also going to be using this package as a template, and I don't want people on our team to forget to put that task in the pre-execute handler.

    I opted with just adding a hardcoded piece to our log start variables script task. Not even remotely happy with it, but at least it's in an obvious place for our template.

    -------------------------------------------------------------------------------------------------
    My SQL Server Blog