Hi,

I've been trying to setup the framework management per CH02;

I've got below warning message (copied the information message 1&2 here as well to help you understand my settings). I've tried to delete all configurations from the package, and re-create per chapter 02 steps, it remains the same.

could any one shed some light here please?

{
Message 1 Information while loading SSIS_PDS_Template.dtsx: The package is attempting to configure from the XML file "C:\Work\SSIS_CONFIG\SSIS_Management_Framework.dts Config". C:\__Min\temp\SSIS_PDS\CH02 Framework Code\Framework\Framework\SSIS_PDS_Template.dtsx 1 1

Message 2 Information while loading SSIS_PDS_Template.dtsx: The package is attempting to configure from SQL Server using the configuration string ""SSIS_PDS";"[dbo].[SSISConfigurations]";"CommonConfigurations";". C:\__Min\temp\SSIS_PDS\CH02 Framework Code\Framework\Framework\SSIS_PDS_Template.dtsx 1 1

Warning 3 Warning loading SSIS_PDS_Template.dtsx: The configuration entry, "停捡慫敧嘮牡慩汢獥啛敳㩲挺湯䅮癤湥畴敲潗歲䑳㉗〰崸倮潲数瑲敩孳慖畬嵥", has an incorrect format because it does not begin with the package delimiter. Prepend "\package" to the package path. C:\__Min\temp\SSIS_PDS\CH02 Framework Code\Framework\Framework\SSIS_PDS_Template.dtsx 1 1


Warning 4 Warning loading SSIS_PDS_Template.dtsx: The package path referenced an object that cannot be found: "停捡慫敧嘮牡慩汢獥啛敳㩲挺湯䅮癤湥畴敲潗歲䑳㉗〰崸倮潲数瑲敩孳慖畬嵥". This occurs when an attempt is made to resolve a package path to an object that cannot be found. C:\__Min\temp\SSIS_PDS\CH02 Framework Code\Framework\Framework\SSIS_PDS_Template.dtsx 1 1

}

Kind Regards,
Min

Hi Min,

If you create a configuration from a fresh package, does it give you the same error message? I wonder if there's a language conversion issue that's happening somewhere along the way.

Jessica

Hi Jessica,

Thank you very much for the reply.

I've finally implemented the solution successfully.

The problem was the create table script for 'SSISConfigurations' table.
For some reason, I did not use nvarchar data type, and I did not follow the field length either .

The table was like this before:

CREATE TABLE [dbo].[SSISConfigurations]
(
[ConfigurationFilter] varchar(50)
,[ConfiguredValue] varchar(500)
,[PackagePath] varchar(200)
,[ConfiguredValueType] varchar(50)
)

and now it is now like this:

CREATE TABLE [dbo].[SSISConfigurations]
(
[ConfigurationFilter] nvarchar(255) NOT NULL
,[ConfiguredValue] nvarchar(255) null
,[PackagePath] nvarchar(255) not null
,[ConfiguredValueType] nvarchar(20) not null
)

I have no more problems in the package for package configuration framework :).

Thank you.

Kind Regards,

Min