e-mail warnings

[zatch]

Hello -

Does anyone have any thoughts as to how one would e-mail a list of warnings and/or e-mail an entire log file?

I am trying to notify myself when the OnWarning event fires on a package. I can not figure out to access the log files.

Thanks.

Mitch

 

[zatch]

I've solved this. It was much simpler than I thought. Here are the steps I used:

Go to the the Event Handlers tab of the package.

Choose and Executible and Event handler from the Dropdownlists. In my case, I chose my package, and the "OnWarning" handler.

Add a Send Mail Task to the designer.

Go to edit mode of Send Mail Task.

Fill in properties as you usually would, except:

Set MessageSourceType property to Direct Input.

Leave MessageSource property blank.

In the "Expressions" page of the edit mode of the Send Mail Task, and a new expression.

For the new expression, choose MessageSource for the property and type "@[System::ErrorDescription]" for the Expression (or create your own custom expression by clicking on the elipses button.)

Mitch