Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Advanced Event Behavior – Level 10 of the Stairway to Integration Services Expand / Collapse
Author
Message
Posted Wednesday, November 28, 2012 12:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 25, 2016 11:39 AM
Points: 393, Visits: 1,092
Comments posted to this topic are about the item Advanced Event Behavior – Level 10 of the Stairway to Integration Services

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
Post #1389524
Posted Thursday, February 7, 2013 3:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 22, 2016 1:51 PM
Points: 22, Visits: 299
A bit confused, The code and listing associated with figure 19 is very different form the code that was perviously tested in the Script Task 4 OnError script task. Did I miss something?
Post #1417369
Posted Monday, October 12, 2015 9:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 25, 2016 12:22 PM
Points: 4, Visits: 32
A bit stuck here, I have added control to set the Propagate variable to false in the Script Task 4 Event handler, yet my error still propagates... Not sure what I missed.
Post #1727273
Posted Wednesday, March 2, 2016 7:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 2, 2016 1:51 PM
Points: 14, Visits: 23
Andy,

Thank you so much for doing the SSIS Stairway. I recently started a new job and needed to come up to speed quickly.

Your tutorials were just what I needed. I also found it very helpful that you recapped the previous lesson each time. It helped me double check that I had completed it correctly before moving on :)
Post #1765921
Posted Wednesday, November 9, 2016 8:47 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 9, 2016 9:49 PM
Points: 10, Visits: 82
I've been working through this in SSIS 2012 and came across a couple of things that might be helpful for anyone behind me:

1. The Variables window no longer shows System variables, by default. There is a checkbox in Variable Grid Options to turn that back on, or you can drill down via Package Explorer to get to them.

2. The ErrorCode in Listing 1 is now 6, not 8:
        If iErrorCode = 6 Then
Dts.Variables("Propagate").Value = False
Else
Dts.Variables("Propagate").Value = True
End If

3. An external (file system-based) package should have ReferenceType = External Reference and Location = File system. Project Reference works if the package is already in your solution (i.e. visible in Solution Explorer) as in the example.
Post #1833354
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse