The souce code is not complete and all information is not in the backup. The SSIS Configurations table is not present. I can create it without a problem. The script to insert values does not include the LoadMonthlyInventoryData configuration. I created the environment variable, but do not know what should be configured for LoadMonthlyInventoryData in the configuration table so the template package won't load.

Hi saraftatum,

The second SQL Server configuration entitled "Package Level Configuration" that uses the Filter "LoadMonthlyInventoryData" is a placeholder for any package level specific configurations. Because this is a template package for you to modify and set up, you wouldn't start with any of these configurations. You would set up the system level configurations, such as the connection string link to all databases, i.e. AdventureWorks. Once those are set up and the package is distributed to developers, that would add the package level configurations. If it makes it easier to understand, you could remove that package level configuration from the template because all new packages will need to create/modify it.

I just reset everything on a new computer and was able to get the package to load and run without having any configurations linked to that filter. Are you receiving a particular error message?

Thanks,
Jessica

Pls can someone help me out. Trying to configure the SSIS Management Framework, i am get the follong warnings:

Information: 0x40016041 at SSIS_PDS_Template: The package is attempting to configure from the XML file "C:\SSIS_PDS\CH02 Framework\~CA".
Warning: 0x80012012 at SSIS_PDS_Template: The configuration file name "C:\SSIS_PDS\CH02 Framework\~CA" is not valid. Check the configuration file name.
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""HP-PC\ZION.SSIS_PDS";"[dbo].[SSIS Configurations]";"CommonConfigurations";".
Warning: 0x80012059 at SSIS_PDS_Template: Failed to load at least one of the configuration entries for the package. Check configuration entries for "XML Configuration" and previous warnings to see descriptions of which configuration failed.
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\~CA".
Warning: 0x80012012 at SSIS_PDS_Template: The configuration file name "C:\SSIS_PDS\CH02 Framework\~CA" is not valid. Check the configuration file name.
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""HP-PC\ZION.SSIS_PDS";"[dbo].[SSIS Configurations]";"CommonConfigurations";".
Warning: 0x80012059 at SSIS_PDS_Template: Failed to load at least one of the configuration entries for the package. Check configuration entries for "XML Configuration" and previous warnings to see descriptions of which configuration failed.
SSIS package "SSIS_PDS_Template.dtsx" finished: Success.

Hi kev4king,

The package cannot find the file "C:\SSIS_PDS\CH02 Framework\~CA" for configuration. Try removing the tilde from the environment variable value and make sure that it matches the file location.

HTH,
Jessica

Hello Jessica,

Thanks a lot for your swift response. When you mean remove the tilde from the environment variable, do you mean ~.

I did tried using my other computer but this is the error i am getting. Prior to that, anytime i run the query on each of the stored procedure it says Incorrect syntax near '?'.

Pls i really need help so i can get this sorted out of the way.

These are the errors:

Information: 0x40016041 at SSIS_PDS_Template: The package is attempting to configure from the XML file "C:\SSIS_PDS\CH02 Framework".
Warning: 0x80012012 at SSIS_PDS_Template: The configuration file name "C:\SSIS_PDS\CH02 Framework" is not valid. Check the configuration file name.
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""KINGDOM\KEVIN.SSIS_PDS";"[dbo].[SSIS Configurations]";"CommonConfigurations";".
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""KINGDOM\KEVIN.SSIS_PDS";"[dbo].[SSIS Configurations]";"LoadMonthlyInventoryData";".
Warning: 0x80012059 at SSIS_PDS_Template: Failed to load at least one of the configuration entries for the package. Check configuration entries for "XML Configuration" and previous warnings to see descriptions of which configuration failed.
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".
Warning: 0x80012012 at SSIS_PDS_Template: The configuration file name "C:\SSIS_PDS\CH02 Framework" is not valid. Check the configuration file name.
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""KINGDOM\KEVIN.SSIS_PDS";"[dbo].[SSIS Configurations]";"CommonConfigurations";".
Information: 0x40016040 at SSIS_PDS_Template: The package is attempting to configure from SQL Server using the configuration string ""KINGDOM\KEVIN.SSIS_PDS";"[dbo].[SSIS Configurations]";"LoadMonthlyInventoryData";".
Warning: 0x80012059 at SSIS_PDS_Template: Failed to load at least one of the configuration entries for the package. Check configuration entries for "XML Configuration" and previous warnings to see descriptions of which configuration failed.
Error: 0x0 at SQL LogTaskPreExecution: 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 SQL LogTaskPreExecution, 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: SQL LogTaskPreExecution
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 SQL LogTaskPreExecution: 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: SQL LogTaskPreExecution
SSIS package "SSIS_PDS_Template.dtsx" finished: Success.

Hi kev4king,

The important message in this set of messages is here: "The configuration file name "C:\SSIS_PDS\CH02 Framework" is not valid. Check the configuration file name."

The environment variable value should have the full file name (such as C:\SSIS_PDS\SSIS_Management_Framework.dtsConfig), and that file needs to be in the location. Make sure there aren't any line breaks or anything in the name.

It might help to walk through all the steps in the Solution section of Chapter 2 again to make sure you've got all of the pieces in place.

Jessica

Hi Jessica,

Thanks a lot for your reply. I am doing the parameter mapping on the execute SQL Task Editor but when i clicked on the Result Set to do the mapping setttingd the Add button id grayed out.

Pls can u assist me to get out of this

Thanks
Kev4king

Hi Jessica,

After setting the parameter mapping on the Execute SQL Task Editor, when I clicked on the 'Result Set' to map the settting, the Add button is grayed out

Pls can you assist me to get to get this sorted

Thanks
Kev4king

Hi kev4king,

It sounds like SSIS can't make a connection. Have you fixed the previous errors that you were facing?

Jessica

No. I started all over again.