.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

Run a package for multiple servers (configurations)

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

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?




View Complete Post

More Related Resource Links

One SSIS package - multiple configurations?

I'm looking for a basic guideline/best practices for creating an SSIS setup involving one "master" package called with one variable that will link it to a set of configurations based on that variable. Currently we create a new package for each client, each with their own configuration. Now each package is basically the same but we create an entirely new package file for each customer. There are variables that are of the YES/NO variety to enable/disable specific functions based on client need. As it is now, if we improve the package (a new version if you will) we have to go back to all prior packages to update and make the adjustment. These can be anything from a small SQL code change to an entirely new container of tasks. Either way, you get the idea, this is very inefficient and I am attempting to standardize our packages and process. If anyone could post a few links or point me in the right direction it would be very much appreciated. Thank you!

Collecting data from multiple servers

I have a list of about 500 servers that I am trying to connect to and collect various amounts of information from these servers through one query. I'd like to have something that doesn't involve OS batch scripting or using SQLCMD as the SQL Instances range from SQL 2000 through SQL 2008 R2. Does anyone have any suggestions or ideas on what to do to accomplish this?Big Ern

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.

Deploying SSIS Package configurations in production and development


I'm working on a SSIS package which I want to deploy onto our development environment on a daily basis as I work on it. In addition, I want it to be easy to deploy to production. We're using xml configuration files for our packages, but I haven't seen anyone discuss the entire development process.

Do people keep their production and development configuration files in source control? If so, how? Are they part of your BIDS SSIS project? I tried adding them to "Miscellaneous". i.e. Example:

I have a project with the following SSIS Packages in it:




In the Miscellaneous folder I have:






I did this so I can keep them in source control. We don't use package deployment utilities, we just deploy by hand, but putting the files in Miscellaneous breaks the building of the deployment utilities because it attempts to copy the config files into the Deployment directory twice.


In addition, I set up the package configurations such that the

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

Scheduling a Job and using Package Configurations


All of my SSIS packages use Package configurations. I have built a wrapper package that  runs my Daily Data Warehouse process.

In that wrapper package there are many Execute  package tasks that execute the various SSIS packages within my Data Warehouse process (all which use Package Configurations). My question is when I create a scheduled job in the SQL Server Agent for the wrapper package do I need to define only the Package Configuration for the wrapper package. Will each individual Execute Package tasks use its defined package configuration even though it is not part of the job I have created in the SQL Server Agent?

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?

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. 







How to Create multiple flat file import package?

Hello Everyone,

I am an absolutely beginner to SSIS and need to perform the following task.

  • Need to import Master data from (semi colon) ; delaminated flat files into separate tables in SQL Server
  • Each file will create a separate table in SQL Server
  • While importing I need to perform validation on each file and only extract data that is valid e.g. CNIC column must be numeric and 13 digits long.
  • Any data that is not valid will be sent to a separate table with same TableName_bad suffix
  • After the data is extracted I will extract the details data of only those records that have been extracted in master table before

I know about basic data flow controls etc but I don’t know which control will be better for which task. Please tell me what will be the procedure to fulfill my requirements. I will be extremely thankful.



Syed Afraz Ali


SQL Server 2008 R2 Data Collector for multiple servers.


Hello all,

I'm working as a intern and have been maintaining a performance monitoring application for my companies servers and wanted to know if "Performance Data Collector" could do the job for us(and that I've spent the last month working on...) I ran across an article(http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-performance-data-collector/ ) that seemed to describe this tool as pretty much what I've been working on.

Presently we do this:

1. Performance Monitor(perfmon.exe) logs all the performance counters we want and stores them locally on each server.

2. A client service(run on each server we monitor) takes the log files, zips them and periodically transfers them to the logging server.

3. Once on the logging server another service parses the files and bulk uploads them into a SQL Server 2008 R2 Database.

4. A SSAS cube on the logging server then processes all the data and we have our min/max/averages for the various counters.

Can I collect performance data from Windows 2008 servers that do not have SQL Server 2008/2008 R2 installed on them by using the server that is running the collector to pull the information? This would essentially b

How can I distribute SRS report to multiple servers?

I work in an environment with multiple tiers of SCCM servers. I produce SRS reports on Tier 2 level site server and would like to be able to distribute some of these to the lower (Tier 3 and Tier 4) site servers so that local admins can run them as frequently as needed without hitting the Tier 2 database. Is there some way to do this without having to logon to each (40 of them) SSRS server and adding them?

Dynamic PAckage to import multiple excel 2007 files in SSIS 2005


I want to import multiple excel 2007 files into Sql Server Database using SSIS 2005.

Can someone explain me the steps as i am new to SSIS.

Multiple state servers


Is there a single server allowed only as a state server for a group of servers which are load balanced? There are 5 servers load balanced. The site hosted on these servers uses a state server. Is there a way to use another set of servers as state servers? I don't think the web.config allow you to set multiple state servers for the same site. Is that something possible?



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.
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