Wrox Programmer Forums
|
BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution
This is the forum to discuss the Wrox book Microsoft SQL Server 2008 Integration Services Problem-Design-Solution by Erik Veerman, Jessica M. Moss, Brian Knight, Jay Hackney ; ISBN: 978-0-470-52576-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 8th, 2012, 11:04 AM
Registered User
 
Join Date: Mar 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Framework Issue (Chapter 2)

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
 
Old May 9th, 2012, 04:34 PM
Authorized User
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 2 Framework Execution and Logging coyoteJohn BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution 1 January 27th, 2012 02:20 AM
Chapter 14 Linq and ado.net entity framework pandukal21 BOOK: Beginning ASP.NET 4 : in C# and VB 8 January 28th, 2011 05:19 AM
Entity Framework v1 issue Olin BOOK: Professional ASP.NET MVC 2 2 January 24th, 2011 04:49 PM
Zend Framework Related Issue Rajat Kumar Beginning PHP 0 May 6th, 2008 07:00 AM
Validator framework, chapter 12 inkimar BOOK: Professional Jakarta Struts 0 August 24th, 2006 04:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.