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 December 23rd, 2011, 06:29 PM
Registered User
 
Join Date: Dec 2011
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 2 Framework Execution and Logging

I am new to many of the concepts in the book so I am probably making some rookie mistakes (at least I hope so because somebody out there can probably set me straight quickly).

I have the package template working until I try to do a execute package task from the template.

On even the simplest parent child execution I get the following two errors:

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PackageTaskLog_PackageLog". The conflict occurred in database "SSIS_Config", table "dbo.PackageLog", column 'PackageLogID'.

Executing the query "exec dbo.LogTaskPreExecute @PackageLogId = ? ,@Sou..." failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Both errors are thrown by the pre execute log task (from the event) in the child package (these errors do not occur if the child is run directly - outside of the parent)

Also all of the package tasks are logged twice after the child package starts (see below):

PackageTaskLogID PackageLogID SourceName
37 47 Sequence Container
38 47 Parent unit master data flow task
39 47 Execute Package Task
40 47 Log Task Pre Execute <-- This is the task that throws the errors
41 47 AOD Extract PA Unit Master
42 47 Log Task Pre Execute
44 47 Log Package Start
45 47 Log Task Post Execute
46 47 Log Task Pre Execute
47 48 PA Unit Master Sequence
48 47 PA Unit Master Sequence
49 47 Log Task Pre Execute
50 48 PA Unit Master Extract to flat file
51 47 PA Unit Master Extract to flat file
52 47 Log Task Post Execute
53 47 Log Task Post Execute
54 47 Log Task Pre Execute
55 48 Log Package End
56 47 Log Package End
57 47 Log Task Post Execute
58 47 Log Task Post Execute

I cannot tell if this is a symptom of the error or of my design.

More interesting is that the same source for the two errors is called 4 more times during the running of the package none of the following executions throws an error.

Any help will be greatly appreciated - I really don't want to lose this weekend!

Thanks
 
Old January 27th, 2012, 02:20 AM
Authorized User
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi John,

I answered your question on the other thread: Foreign Key issues with framework when starting several packages from a master.

Jessica





Similar Threads
Thread Thread Starter Forum Replies Last Post
Framework Configuration Management CH02 - Turn logging on/off (Share experience) minnie.schurr BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution 1 April 16th, 2012 04:35 PM
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
Chapter 12 - Logging in mbrad BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 September 12th, 2007 03:22 PM
Validator framework, chapter 12 inkimar BOOK: Professional Jakarta Struts 0 August 24th, 2006 04:07 AM
SSIS - Built-In Logging / Custom Logging ivobecker23 SQL Server 2005 0 April 21st, 2006 05:41 AM





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