Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Problem with having mutiple script tasks in an SSIS Package Expand / Collapse
Author
Message
Posted Thursday, April 29, 2010 10:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 16, 2010 2:08 PM
Points: 6, Visits: 42
Yes I have tried. I have placed break points in the script tasks which fire onerror for the Tasks "Get Previous Run Dates" and "Update SSIS Last run table", but these are ignored by the package. Only Break points in the "Collect All Errors" work. At present I an trying to check this.
Post #913085
Posted Thursday, April 29, 2010 4:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 16, 2010 2:08 PM
Points: 6, Visits: 42
I recreated all the script tasks (previously I had created one and then copied it over) but still find the same problem. Breakpoints set in the script tasks for the onerror message are ignored by the package when it runs.

Finally I have put in code to remove the duplicate error messages before sending the email.

If anyone comes up with a reason for this behavior please let me know
Post #913320
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse