Advanced Event Behavior – Level 10 of the Stairway to Integration Services

  • Andy Leonard

    SSCrazy Eights

    Points: 9895

    Comments posted to this topic are about the item Advanced Event Behavior – Level 10 of the Stairway to Integration Services

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • David E. Akin

    SSC Enthusiast

    Points: 158

    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?

  • kayasmith106

    Valued Member

    Points: 66

    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.

  • gogniben

    SSC Veteran

    Points: 204

    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 🙂

  • John_B

    SSC Enthusiast

    Points: 155

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply