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

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.

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