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

Hi John,

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

Jessica