Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old December 29th, 2009, 04:41 PM
Registered User
 
Join Date: Dec 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Framework

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.
  #2 (permalink)  
Old January 4th, 2010, 12:57 AM
Authorized User
Points: 84, Level: 1
Points: 84, Level: 1 Points: 84, Level: 1 Points: 84, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default No Package Level Configurations Needed

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
  #3 (permalink)  
Old January 20th, 2011, 07:27 PM
Registered User
Points: 29, Level: 1
Points: 29, Level: 1 Points: 29, Level: 1 Points: 29, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
  #4 (permalink)  
Old January 23rd, 2011, 02:03 AM
Authorized User
Points: 84, Level: 1
Points: 84, Level: 1 Points: 84, Level: 1 Points: 84, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #5 (permalink)  
Old January 24th, 2011, 08:37 AM
Registered User
Points: 29, Level: 1
Points: 29, Level: 1 Points: 29, Level: 1 Points: 29, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Aboout the SSIS Management Framework

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.
  #6 (permalink)  
Old January 31st, 2011, 04:49 AM
Authorized User
Points: 84, Level: 1
Points: 84, Level: 1 Points: 84, Level: 1 Points: 84, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #7 (permalink)  
Old February 3rd, 2011, 07:03 PM
Registered User
Points: 29, Level: 1
Points: 29, Level: 1 Points: 29, Level: 1 Points: 29, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default About the SSIS Managent Framework

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
  #8 (permalink)  
Old February 3rd, 2011, 07:14 PM
Registered User
Points: 29, Level: 1
Points: 29, Level: 1 Points: 29, Level: 1 Points: 29, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
  #9 (permalink)  
Old February 14th, 2011, 02:50 AM
Authorized User
Points: 84, Level: 1
Points: 84, Level: 1 Points: 84, Level: 1 Points: 84, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2009
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi kev4king,

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

Jessica
  #10 (permalink)  
Old February 14th, 2011, 04:14 PM
Registered User
Points: 29, Level: 1
Points: 29, Level: 1 Points: 29, Level: 1 Points: 29, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

No. I started all over again.
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04: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



All times are GMT -4. The time now is 06:21 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.