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 February 28th, 2011, 03:51 AM
Authorized User
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi kev4king,

On the General tab, did you set the ResultSet property? You'll need to change that so that you can add the ResultSet option.

Jessica
 
Old September 15th, 2011, 01:36 PM
Registered User
 
Join Date: Aug 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default SSIS TEMPLATE PACKAGE

Someone help please.

I am having the following errors.


Information: 0x40016041 at SSIS_PDS_Template: The package is attempting to configure from the XML file "C:\SSIS_PDS\CH02 Framework Code\SSIS_PDS_Template Package.dtsConfig".
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""SONY-PC\KEV.SSIS_PDS";"[dbo].[SSIS Configurations]";"CommonConfigurations";".
SSIS package "SSIS_PDS_Template.dtsx" starting.
Information: 0x40016041 at SSIS_PDS_Template: The package is attempting to configure from the XML file "C:\SSIS_PDS\CH02 Framework Code\SSIS_PDS_Template Package.dtsConfig".
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""SONY-PC\KEV.SSIS_PDS";"[dbo].[SSIS Configurations]";"CommonConfigurations";".
Information: 0x40016042 at SSIS_PDS_Template: The package is attempting to configure from the parent variable "BatchLogID".
Warning: 0x8001201A at SSIS_PDS_Template: Configuration from a parent variable "BatchLogID" did not occur because there was no parent variable collection.
Error: 0x0 at Log Task PreExecute: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PackageTaskLog_PackageLog". The conflict occurred in database "SSIS_PDS", table "dbo.PackageLog", column 'PackageLogID'.
Error: 0xC002F210 at Log Task PreExecute, Execute SQL Task: Executing the query "
exec dbo.LogTaskPreExecute
@PackageLogID = ?
,@So..." 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.
Task failed: Log Task PreExecute
Warning: 0x80019002 at OnPreExecute: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Warning: 0x80019002 at OnPreExecute: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Warning: 0x80019002 at Log Task PreExecute: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: Log Task PreExecute
Warning: 0x80019002 at OnPreExecute: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Warning: 0x80019002 at Log Task PreExecute: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: Log Task PreExecute
SSIS package "SSIS_PDS_Template.dtsx" finished: Success.
 
Old September 17th, 2011, 12:11 PM
Authorized User
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi kev4king,

The important message is here:
Error: 0x0 at Log Task PreExecute: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PackageTaskLog_PackageLog". The conflict occurred in database "SSIS_PDS", table "dbo.PackageLog", column 'PackageLogID'.

When you run the package, you want to see what the PackageLogID is that it is trying to use to insert into the PackageTaskLog table. My guess is that it is 0 because it's not getting set properly by one of the prior tasks. Is the initial start task still set up correctly?

Jessica





Similar Threads
Thread Thread Starter Forum Replies Last Post
Which Javascript FrameWork to use? chobo2 Javascript 0 May 26th, 2008 02:54 PM
changing host server framework 2.0 from framework jay_vijesh ASP.NET 1.x and 2.0 Application Design 1 September 11th, 2006 02:18 PM
How use framework components in compact framework? r_bazghaleh C# 0 February 19th, 2006 05:05 AM
Framework 1.0 to 1.1 reyboy General .NET 2 September 16th, 2004 02:12 PM
.Net Framework Indian Ocean .NET Web Services 1 July 23rd, 2003 12:01 AM





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