.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Runtime Package Configuration Problems

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
I have been reading a few other threads on this topic but so far nothing is helping.  My ETL package runs perfectly in my development environment but my attempts to create package configurations so that things like connection strings can be changed for the production environment without modifying the package are not working...  To be clear I can get things like the connection string to my "target" ETL database to work just fine using an XML config file.  However I seem to be running into a problem where even though at run-time my package may pay attention to certain config settings, it first validates the development settings (which are not right in the production environment hence it fails). On this microsoft page ->http://msdn.microsoft.com/en-us/library/ms141682.aspx under the section entitled "Understanding How Package Configurations are Applied at RunTime" it says... "When you use the dtexec command prompt utility (dtexec.exe) to run a deployed package, the utility applies package configurations twice. The utility applies configurations both before and after it applies the options that you specified on command line" I think this may be the root of my problem... why in the world would it first apply the "before"configuration?!?!?! (ie "the configuration before it applies the options" ) Afterall, the conf

View Complete Post

More Related Resource Links

Package Configuration Problems SQL 2008 R2

I have an SSIS package that is using a SQL Server configuration to store connection strings for the other connection managers used by the package.  The connection string for the connection manager used to get the SQL Server configuration data is passed to DTExec when the package is executed.  The SQL configuration sets the values of variables that hold the connection strings and the connection managers use the variables in an expression to set the connection string.  I'm doing this so that I can move the packages from dev to qa then to production.  I also need to have the child packages use the same connection strings as the parent package so each child package has a parent package variable configuration containing the connection strings.  It uses these to set the values of child package variables which are then used to set the connection string property of the connection managers using an expression. I tested my packages by connecting to the development SSIS server, clicking on the package and selecting run package.  I select the connection managers tab so that I can change the connection string of the connection manager that points to the SSIS Configurations table which contains the development connection strings.  This works great. I deployed my packages to the production server and again tested the packages by running them from the pr

Package Configuration causing problems with Oracle Connection


Hi All,


We need to import the data from Oracle 10g database to SQL Server 2005 database.

Solution Picked:

In order to accomplish the above, we used SQL Server Integration Services along with Business Intelligence Developer Studio.


Base Details:

There are around 17 packages, each retrieving data from Oracle and storing into SQL Server based on current date. Following are the steps used:

  1. Get current date from SQL Server [Execute SQL Task].
  2. Create Query based on date obtained from step (1) [Script Task].
  3. Based on query obtained from step (2). Inside a [Data Flow Task] following sub actions are performed:

    Actions performed in [Data Flow Task]

  1. Retrieve data from Oracle database using query through [OLE DB Source].
  2. Perform any data modifications to correct the data [Derived Column].
  3. Store data in SQL Server [OLE DB Destination].
  4. Rejections are saved in text file [Flat File Destination].

Problems posting to a package


Hey Y'all

I'm currently creating a program that accesses a mysql package to add data to a few tables.  I'm currently getting an error that says  "

ORA-01403: no data found
ORA-06512: at "JESSE.PKG_WORKPLAN", line 42
ORA-06512: at "JESSE.PKG_WORKPLAN", line 177
ORA-06512: at line 1


These lines are


and 177:add_team_members(V_PROJECT_ID, V_START_DATE, v_FISC_YEAR, V_MEMBERS ,V_NUM_MEMBERS,'add');

Checking these variables in my asp.net page they are all receiving parameters.

Is there a  way to see what the database is actually receiving from the asp.net page?

Or is there another thing to be looking at?


Problems running a bat file within a SSIS package

I have a ssis package which has 2 tasks, first it builds an excel sheet with data on the server from where I am running the ssis pkg and the second task (a sql process task), runs a bat. the bat file that basically copies the  excel sheet created from the first step to another server. Problem is that the ssis pkg runs succesful when i run it from BIDS, bust when I run is as ajon, it gets hung. It completes the first step, it is the sescond step that is get hung. I noticed that when i run from BIDs, it does come up with a window open file - security warning and says the publisher could not be verified, are you sure you want to run this software. why does it do that ??? the file I am asking to run is a .bat file. it should automatically use the cmd.exe app to run the bat file. Please help !!!   Thanks in advance.

Problems with a .NET4 Control GAC Reference failing at runtime but fine during debugging

I believe this question is specific to the CLR how ever I will test this in a Forms Application later. I have multiple .Net 4 Targeted WPF Applications that Reference Non Microsoft .NET 4 WPF Controls that I can confirm are in the GAC. Everything Debugs Great (Noting that none of the references are copied to the output directory) and Install's well using a Setup Package and manually installing has the same effect even after a reboot. The problem is the application will not start even as an administrator as it does not find the Control References in the GAC. This also happens if I try to start the application manually in the visual studio output Directory. I can also confirm that opening the application in reflector that reflector is able to correctly find the references. Finally if I copy the controls (.dll's) to the location of the application everything runs as expected for all the above issues.   My question here is why is my application not able to load the .NET 4 controls from the GAC? Also note that everything uses a Strong Name.

SSIS package - change Web reference's addres from Configuration file?

Greetings. The SSIS packages provide very nice options to configure them from an XML file, which allows to change credentials, database names etc w/o editing the package. This lets me, say, transfer package from one server to another or from test to production w/o any hassle - just changing the xml. Problem is, i need to acces a web service in my package, and built-in SSIS web service task is useless and just SUCKS. It fails to work even with miscrosoft's own sharepoint web service. So, i have to use scripting task. And scripting task uses "web reference" to access web services, which in turn gives no way to change it's url.  So, if i want to test and then move to production, i'll have to edit my package to change the web reference url from "testserver:5123/mywebservice" to "productionserver:81/webservices/mywebservice". And then change it again to test it again. Etc. Is there a solution to this? A way to programmatically change web reference's url from inside scripting task?

SSIS package fails giving "System.Runtime.InteropServices.COMException" exception


I am trying to execute the package in SQL Server 2008 and i am getting this error.


Executed as user: sql\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    

Started:  11:07:09 AM  Error: 2010-09-20 11:07:10.95     Code: 0x00000000     Source: Transform Data Task  undefined      

Description: System.Runtime.InteropServices.COMException (0x80040428): Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed.     at DTS.PackageClass.Execute()     at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()  End Error  DTExec: 

The package execution returned DTSER_FAILURE (1).  Started:  11:07:09 AM  Finished: 11:07:10 AM  Elapsed:  1.094 seconds.  The package execution failed.  The step failed.


Do any one have a clue


Execute SQL task and Save Package Configuration wizard


Hello Experts,

I am a great fan of using Package configuration in SSIS to ease migration. I am stumped when it comes to sql execute task. We have few execute sql task that requires selecting/updating across mutliple databases in the query. Currently, I am using 4 part name(server.database.schema.table) in query. Doesn't this actualy against theme of using package configuration in SSIS. If I hard code server and database name, I will have to edit each SSIS package post migration to production.

What options do I have? Can you please help this rookie?




start SSIS package via script task with package configuration via variables



it is possible to start ssis packages with dtexec and set variables as package configuration like this:

dtexec.exe /SQL "\mart1\import_fact_calls" /SERVER "R08" /SET \package.variables[FullImport].Value;True

Now I'm trying to start a package via script task with this code:

Public Sub Main()
    Dim pkg As New Package
    Dim app As New Application
    Dim pkgResults As DTSExecResult

    If Dts.Variables("package").Value <> "" Then
      pkg = app.LoadFromSqlServer(Dts.Variables("package").Value, "R08", "USER", "PASS", Nothing)
      pkgResults = pkg.Execute()
    End If

    Dts.TaskResult = ScriptResults.Success
End Sub

How can I add a package configuration like the one with dtexec to the script code?

I like any ideas, links, docus ... Thanks!

Package Configuration on multiple environments


Hello Experts,

I have enabled package configurations to Sql Server, so that it would help me to change the connection properties through TSQL.

I have created these packages on 32bit OS (Windows XP), now i facing problem while running these packages on Win 2008 64bit OS.

though it connects to DB and picks up configurations, it's still giving me "connection failed validation" (i have four file folder connection managers)

How should i over come this issue ? please help me


Thanks, Krishna Nellutla

Package configuration file with multiple connection strings


I am using the configuration file to read the connection string in the SSIS packages. In one of my packages i have to use two different connection strings. If i specify the second connection string in the config file, then the current package works well but other packages fails during validation saying the second connection manager does not exist in the package. Is it not possible to have multiple connection string in a single config file?

Failed to load at least one of the configuration entries for the package


When i run my SSIS package through sql server agent, i got the error below.

Please any one tell me abt the reason of this error

(1) I have credential created which used AD directory service account with userid   and password:  Userid=DONTCALL_AppPool

(2) Created a proxy which use the creddential above

(3) I used Environment variable configuration and sql server configuraion

1984-2005. All rights reserved.    Started:  1:44:41 PM  Error: 2010-10-01 13:44:42.16     Code: 0xC0202009     Source: DontCall Connection manager "CRBSSISConfig"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'CBCINTERNAL\DONTCALL_AppPool'.".  End Error  Warning: 2010-10-01 13:44:42.16     Code: 0x80012059     Source: DontCall      Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.  End Warning  Error: 2

Possible problems with this 2005/2008 configuration?


Hi -- My company is in the process of upgrading their SQL Server 2000 data warehouse to SQL Server 2008.  Note that my company currently uses the BI toolset from SQL Server 2005.  However, my company has no plans to upgrade the 2005 BI services that we currently use.  Will this configuration work? 

Back-end Database Engine: SQL Server 2008, SP-2
Back-end BI Services: SQL Server 2005, SP-3 (SSAS, SSIS, SSRS - each on their own server)
Front-end Client Tools: SQL Server 2008, SP-2 (SSMS, BIDS)

My concern is that I would, for example, develop an SSIS package on my laptop with the 2008 client toolset and it would work just fine.  But when the package is run in production on the SSIS box (that contains only the 2005 SSIS service), it might complain because it doesn't understand the 2008 package structure.  Or is the SSIS service smart enough to detect the version of the package and work as if nothing was wrong? 

Thanks in advance for your help.


SSIS package is not reading from the configuration file in job step configuration tab

Hi everyone,

I have the following question. I have an SSIS package and it has in SSIS in BIDS 'Enable package configuration' and a full path to a file. The packages works ok and reads from this file.

 If I invoke the same package from sql agent as a job step and apply another configuration file in the job step (in tab COnfigurations), the package still uses the one in BIDS. Shouldn't this new config file overwrite the one from BIDS or?

Thank you


Problems reconciling design time and runtime size of WPF Canvas


Hi, there I am using Visual Studio 2010. I am having trouble with the calculation of the size of my canvas and the positioning of the objects thereupon.

Please consider the following simplest of XAMLs:

<Window x:Class="test01.MainWindow"



 Title="MainWindow" Height="350" Width="525">

 <Canvas Margin="0">

 <Label Canvas.Left="505" Canvas.Top="310" Content="Label" Height="28" Name="label1" Background="Blue" />

 <Label Canvas.Left="-36" Canvas.Top="310" Content="Label" Height="28" Name="label2" Background="Red" />




1) The margins of the canvas are 0

2) at design time I see no part of either the blue label or the red label overlapping my canvas as displayed in Visual Studio

I am unable to explain why at runtime:

1) I see a portion of the blue label.

What is happening here? How can I get a better grip on the real size of my canvas at design time?


Edit: OK in case it isn't clear, the problem here is that I wou

parent package configuration help


Hi Guys,

I have two variables vFileExistsDS and vFileExistsTLG both have a Boolean DataTypes. I have a script task that gives both variables a value if the file is exists or not in their respective directories. Now, I want to have a email functionality that gives me an information if one or both directory are empty. I want it be dynamic enough that I need to pass the value of both variables in the child package and use the variables in the "Subject" for the email message.


From the parent package the vFileExistsTLG = False and vFileExistsDS = True then the email message should be "No TLG files in the specified direcotry" and vice versa.

From the parent package the vFileExistsTLG= False and vFileExistsDS = False then the email message should be " No TLG and DS files in the specified directory".

I am having difficulty in configuring the parent package configuration. Can anyone help me?


dtutil and package configuration


I have a requirement listed in the below:

1. package project1 need to deploy both to MSDB\A and MSDB\B on the same SQL Server.

2. All the packages under MSDB/A should use configuration files stored in C:\A
    All the packages under MSDB/B should use configuration files stored in C:\B
    Configuration for these two folder are different such as link to different db connection.

My questions:
1. Can I use package deployment window to meet the requirement? From posted topic looks I can not deploy packages to subfolder.

2. If I use dtutil.exe, can it support for configuration files? where to set the configuration files location.

Great thanks





ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend