hi all !

I would like the last task of my package workflow to send an email with the
package log.

the problem is that the email is sent, but the attachment contains the
package log "before" the package started.

so the question is: how would you do to send the package log, as soon as
possible after the package ends running ?

thanks in advance,
ant.

Package log gets updated only at the end of the package, so that is the
expected behavior.

Here's something to try. If you call this package from a parent package,
using 'Execute Package task', and have a step in the parent package that
emails the log file, once the child package completes. I haven't tried this
though.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


"Antonio Lopez Arredondo" <adog (AT) someplace (DOT) com> wrote

hi all !

I would like the last task of my package workflow to send an email with the
package log.

the problem is that the email is sent, but the attachment contains the
package log "before" the package started.

so the question is: how would you do to send the package log, as soon as
possible after the package ends running ?

thanks in advance,
ant.

As you have noticed, this cannot be done from within the package, since the
log information is not written until the package completion itself.
You would have to handle the mailing of the log in an external component,
immediately after calling the package, such as a second SQL Agent job step.

You could query the SQL Server logging tables, as these are written to in
real-time.


--
Darren Green
http://www.sqldts.com


"Antonio Lopez Arredondo" <adog (AT) someplace (DOT) com> wrote