December 11, 2009 at 1:00 pm
I want to capture that failure message for any failing script and email that output file to the user group.
If you've set up the script task inside the event handler, then the error code and error message is captured inside of your user variables. The next stop is setting up the Send Mail task and configuring it to only run when there is an error.
Have you set this part up as instructed? If so, what part is not working?
December 11, 2009 at 1:52 pm
John Rowan (12/11/2009)
I want to capture that failure message for any failing script and email that output file to the user group.
If you've set up the script task inside the event handler, then the error code and error message is captured inside of your user variables. The next stop is setting up the Send Mail task and configuring it to only run when there is an error.
Have you set this part up as instructed? If so, what part is not working?
John,
I will be working this on tonight and will update you tomorrow. Actually I have done till the part of event handler and used the code that you mentioned.
I will use that variables
Also the variables you mentioned
User::ErrorCode and User::ErrorCode
I created as Int32 and string with values 0 and 1
in the send email task ...
If that works, it would be gr8. I will give a shot ! 🙂
One more thing that if I create a configuration file, then to use the variables do I have to check the variables box to include them in the config file.
Thanks for all u r help,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
December 11, 2009 at 2:08 pm
For the config file, only check the boxes of the items/variables that you want to be able to change from outside the package. I would imagine that most of what we've discussed thus far would not be in a config file.
A config file would be a great place for a variable used to store the email address of the person/group that you would want to receive the email notifications.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply