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

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

Package Configuration on multiple environments

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server

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

View Complete Post

More Related Resource Links

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?

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

Can multiple branches of a package use the same variables

Can multiple branches of a package use the same variables. I don't want to create new variables for each branch .I am getting an error in one of the script tasks  "The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there."  Assuming I dont have a naming error  what else should I look for.

Runtime Package Configuration Problems

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

DtsConfiguration - One configuration value to multiple paths?

I have an SSIS solution with two packages in it. One is a job that runs daily, and the other is a historical (which wipes the database and re-imports everything from scratch). Both packages need nearly identical values to run. Originally the data flow task in both packages had the same name - "Data Flow Task", and I could use the one set of configurations in the dtsConfig file. I've since renamed the Data Flow Tasks in both packages to - DFT Daily and DFT Historical respectively. So now I have a problem - do I duplicate all of the configuration entries, or is there a way to get a single configuration entry "deployed" into both packages' data flow tasks? So here is an example of what I had: <Configuration ConfiguredType="Property" Path="\Package\Data Flow Task.Variables[User::ProxyUsername].Properties[Value]" ValueType="String"> <ConfiguredValue>jplenderleith</ConfiguredValue> </Configuration> <Configuration ConfiguredType="Property" Path="\Package\Data Flow Task.Variables[User::RequiresProxy].Properties[Value]" ValueType="Boolean"> <ConfiguredValue>True</ConfiguredValue> </Configuration> Here is what I don't want to do: <Configuration ConfiguredType="Property" Path="\Package\DFT Historical Rates.Variables[User::ProxyUs

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?

Multiple Source connections in Configuration Table

 I am trying to query multiple servers for properties and record those properties in a table for later use.  I can make this work with the ForEachEnumerator by querying a table. However, I would like to use the Package Configurations option if I can instead.  Any options? Is there a way to force the package to loop through multiple values for one variable, contained in an SSIS configuration table?  Thanks in advance!

Deploy XBAP application with WCF Service Reference into multiple environments

Hi, we have a multiple environment setup (local, Development servers, QA servers, prod servers, etc.) and we are building an XBAP application that uses WCF Services to connect to databases.  We code and unit test everything locally and then deploy to our Development servers for more thorough unit testing.  The issue that we are having is that we don't see how to update the deployed XBAP application to use the Development server deployed WCF Service.  The only way we've been able to do this is by having to change the reference on my local machine, complie, and redeploy the XBAP.Question:  How do we configure a deployed XBAP's Service Reference to point to the same service on a different server than what it was originally compiled/deployed with?  (Like in some configuration file...NOTE: but we also don't see a config file after deploying the XBAP.)  We don't want to have to update the Service Reference for QA, Prod, Training, Stage, etc. on our local machines, compile and redeploy every time we need to migrate the application to a new environment.Thanks!

Multiple configuration files.


I have an application that is deployed into multiple machines and each machine requires a number of specific configuration entries. I was hoping to pick the brains of this group for the best way to mange configuration entries (connection strings, app settings, sevice model, etc.) for multiple machines. I was hoping to have a configuration file that changing one entry would change all of the configuration settings that the application sees. Best would be for the application to "auto detect" the "right" configuration entries but I would be happy if I could limit the configuration edits to one entry. Ideas?

Thank you.


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!

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

Configuration for STS with multiple endpoints


Hello all

I'm trying to configure an STS to have 2 endpoints. First endpoint accepts username client credentials and the second accepts the issued token as client credentials. So my client uses username and password to get a token, and when the token is about to expire I want to renew the token

I'm able to use the first endpoint but the second fails with error: Cannot find a token authenticator for the 'System.IdentityModel.Tokens.SamlSecurityToken' token type. Tokens of that type cannot be accepted according to current security settings.

I've tried to add custom service credentials but the are never hooked up.  

ASP.NET State Server for multiple environments



I have two versions of the same ASP.NET application: developing and test. I want to use one State Server (ASP.NET State Server) machine for both environments. The State Server will run on a separate machine from both developing or test. Can anyone please let me know if there might be any issue ?

Also, I would like to know more information about how the ASP.NET State Server works, how it identifies the machines from which the request for Session comes from, what it actually stores, any articles in this area would be appreciated.



Run a package for multiple servers (configurations)


I have a package that collects information from an SQL Server about the databases on that server. I store this information in a table from where I can create graphs (for example the disk usage, etc.). Now I would like to run this package for about 20 servers. The only difference in the package is the connection of the source DB. What would be the easiest way to do this:

1. Build a loop in the package that runs 20 times and putting the server name in a variable

2. Set package configurations that it runs 20 times with every time a different value for the server of the read db component (is that even possible??)

3. Another option that I don't know of yet?




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


Extracting data from multiple CSV files using SSIS package



I am new to SSIS. I am extracting data from multiple CSV files using SSIS package and copying that data into SQL server 2008  database. Can you please confirm if I can create only one package to handle all CSV files or I will have to create packages for each CSV file.

Column names and numbers are different in all CSV files. 







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