.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

Configurations ...

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
Here I am back to my most favorite topics, configurations! Configurations are extremely confusing in SSIS. Here is the scenario we have. We have a development server X on which we developed a master package which loops through and executes various child packages. All the child packages use a common configuration which is stored in a table on SQL Server. The master package also uses a configuration table for its connections and the SSIS repository. All packages are stored in the SQL Server repository on X. We want to discontinue using Server X and start using a new server Y, hence we copied the solution, package etc., etc., from file system on X to file system Y. We then changed the SSIS repository parameters for the master package to point to Y and saved it to the Y repository. All child packages were saved on Y and the config table values were also changed on Y to point to itself. WHen we execute the packages on Y, it still dumps data onto X. I am not sure what we are doing wrong. Would appreciate any help or feedback!  Jagannathan Santhanam

View Complete Post

More Related Resource Links

Change the .NET framework configurations programmatically.

Hi, I want a code to change the configurations of the .NET framework programmatically( Not the pre-installed configuration tool), I need a sort of library to be able to change it. Thanks Regards Tamer Khalil

COnfigurations stored in SQL Server ...

I have a couple of connections in my package which use configs stored in SQL Server. I am finding that when I open the package in BIDS, the configuration value in the SQL Server table is updated with the information pertaining to the connection in the package. Sounds bizzarre, but I have watched this happen several times. Am I hallucinating or is this intended behavior? I have checked and there is no replication or any process that updates the config tables. Appreciate the feedback.Jagannathan Santhanam

Solution File and Projects Settings/Configurations maintenance.

I am using VS2005 and I have a solution file (.SLN) which has 8 projects. I moved the solution file to a different path on a shared folder to have better organization of my projects and to allow access to the solution/projects from any computer on the network. After that, I edited the .SLN file so that the path of the projects in the solution file are correct (all on shared folders). After that, I opened the .SLN and everything seemd to be working fine. However, I notcied that the "Start Options" of the website part of the solution file is missing the "Start Options", ie, the Start Options are reset to default values. I think also, but not sure, some other settings of the Solution/Projects have been reset. Questions: 1. Where the Web Site "Start Options" are stored ? 2. How I can maintain the Start Options and similar settings if the .SLN file is moved or opened from different computers on the network ? 3. I am not using an team development tools, only plain (vanilla) VS 2005 Prof. Edition. Is it possible to have 2 or more developers work on the same solution/projects (shared on the network), if both developers will coordinate manually simultanous access to the porject files/resources/source code ? Tarek.  

VCProjectEngine dll 9.0 not detecting x64 configurations and platforms

Is there a way to make the .NET framework VCProjectEngine 9.0 dll detect x64 configurations in vcproj files? It seems to ignore them, only caring about Win32.  Thanks, Adam

SharePoint questions with regards to Intranet and Extranet configurations

Hello, I am new to SharePoint configurations and am currently looking at implementing it for our Intranet and then later on down the line, maybe 1-2 years, making it also an Extranet for our clients.  I have a few questions to ask regarding this. 1.  Can a SharePoint Intranet and Extranet run on the same server? 2.  If so, what are the security risks to having the server exposed to the internet as well as the internal network, what are the solutions? 3.  If I use the free version of SharePoint 2010 (Foundation) What are the costs for Intranet client access licenses? and Extranet client access licenses? 4.  Can the SharePoint application run on a separate server from the database? Any help with these questions is greatly appreciated as well as any additional concerns I should have for this implementation. Thanks, Mike

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

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?

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?




XML configurations


I am using SSIS 2005 and have created an XML file to configure 2 connection managers in my packages.  I also have some packages that only have 1 of the connection managers, but if I use the same XML file it will fail stating that it cannot find the 2nd connection manager.  Is there a way that I can use the same XML file to configure packages that only have 1 of the connection managers or do I need to create a separate XML file?



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!

SSAS Configurations for SQL Server Database and Cube on one Server


Currently, my system has SQL Server 2008 and SSAS on one server,

and when querying is active, SSAS shows memory problems.

From the web, I found this document,

SQL Server Databases and cubes on one Server


and as the document suggests, I'd like to change memory related setting for SSAS.

But the document is based on 2005 version.

Any suggested parameter values for 2008 ?

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