November 28, 2012 at 12:05 am
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
February 7, 2013 at 3:19 pm
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?
October 12, 2015 at 9:14 am
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.
March 2, 2016 at 7:44 am
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 🙂
November 9, 2016 at 8:47 pm
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply