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 August 14th, 2011, 08:46 PM
Registered User
 
Join Date: Jul 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Framework management setup CH02 warning mesage

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
 
Old August 27th, 2011, 07:00 PM
Authorized User
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old September 6th, 2011, 10:36 PM
Registered User
 
Join Date: Jul 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
error while sending mesage through CreateUserWizard control jack_hilary BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 September 25th, 2009 03:43 AM
Error message in ch02 Nikolajs BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 November 21st, 2006 04:54 AM
Error Mesage problem gsgreene ASP.NET 1.0 and 1.1 Basics 1 December 31st, 2004 09:10 AM
How can I setup .Net framework from 1.0 to 1.1 kasie General .NET 1 March 7th, 2004 09:19 AM
ch02, cannot run classbrowser ernstG BOOK: Beginning ASP.NET 1.0 0 November 15th, 2003 04:40 AM





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