I’m confused with the diagram (Figure 2-9) on page 53. The confusion stems from the fact that the PreExecute event will and should fail before SSIS executes the “SQL LogPackageStart” task because the PackageLogID variable is set to 0 and it has not been set to the correct PackageLogID. The way that I went around it is to I apply the PreExecute and even the PostExecute at the “SEQ Package Logic” sequence task scope. Therefore, these events will only be executed in the sequence task after the “SQL LogPackageStart” task has run and set the PackageLogID with the correct ID.

Although my package works now, I want to make sure I didn’t miss anything because in the book these events are applied at the package level not the sequence task level.

Gustavo

Hi dspam01,

The stored procedure that the PreExecute phase calls specifically excludes the Start and End tasks to avoid that concern. As long as you don't need to record the executions of any events (that would get called outside of the scope of the package logic sequence container), moving the tasks to the sequence container level should still work for you.

Jessica