.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

DtsConfiguration - One configuration value to multiple paths?

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

How to create an activity that allows multiple exit paths similar to FlowSwitch and FlowDecision

There have been several threads around this type of request but none have provided a definitive outcome for my requirements:I am looking to emulate the FlowSwitch or FlowDecision in a custom activity so as to simplify end user workflow authoring in a rehosted environment.Currenty I am limited to linking my custom activity to a FlowSwitch or FlowDecision to allow for simple logic to be visually composed. This creates additional complexity that I am trying to avoid.I understand that these are sealed types and even the abstract FlowNode base class of these types does not have any overridable types by design as WF 4.0 favours composition over inheritance.What options do I have to accomplish my objective?If activity composition is the response to my question then could I kindly request that some samples or links to samples are provided?

How to create an activity that allows multiple exit paths similar to FlowSwitch and FlowDecision

Hi, I saw replies about create an multi path activity and it's container and they are guid me alot but i can not setup link between two activities in my container with System.Windows.Shapes.Line . can any one help me . can any one send me a sample code please . thanks

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!

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.


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?

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.  

Table may cause cycles or multiple cascade paths


i have a table that contains 3 forign keys ,

2 of them from the same table

when i make Delete Rule  Cascade,this error message appears

'Customers' table saved successfully
'Order' table
- Unable to create relationship 'FK_Order_Customers1'.  
Introducing FOREIGN KEY constraint 'FK_Order_Customers1' on table 'Order' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Could not create constraint. See previous errors.

what is solution,as i want when i  delete data from master table ,all dependent (child) data

automatically deleted, so i use Cascade

thanks ,

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Upload Multiple File using JQuery in asp.net

In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Multiple Column Dropdownlist for the ASP.NET DataGrid

Based on my previous control "Multiple Column DropDownList for ASP.NET", I received many emails asking for the same control to be used in the DataGrid for web applications. Here we go.. This control can be used as the regular MS DropDownList in the DataGrid and also as a regular dropdownlist. It has all the properties, like DataTextField, DataValueField, DataSource, SelectedIndex etc. The download file contains the samples both in VB.NET and C#. In this sample, I have used the Northwind database of SQL Server.

ASP.NET Multiple Selection DropDownList with AJAX HoverMenuExtender

Recently, I was looking for a multiple selection dropdownlist control for my new project. After spending some time researching for it, I decided to put together all my finding in one web user control. This web user control consists of an ASP.NET AJAX HoverMenuExtender, JavaScript, StyleSheet and CheckBoxListExCtrl . The final product will work with or without a MasterPage and you can drag and drop more than one instances of the control on to the page.

Making Sense of ASP.NET Paths

ASP.Net includes quite a plethora of properties to retrieve path information about the current request, control and application. There's a ton of information available about paths on the Request object, some of it appearing to overlap and some of it buried several levels down, and it can be confusing to find just the right path that you are looking for.

jquery autocomplete multiple values


i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?


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