SSIS Configuration

Posted on 2011-04-19
Medium Priority
Last Modified: 2013-11-10
Is the purpose of the configuration where you  click SSIS --> Package Configuration, to set the connection strings of the package such that when/if you have to move it you can go to the config package and make the adjustents?

Is there any other important aspect that one should know about configuration packages.
Question by:SeTech
  • 2
LVL 22

Accepted Solution

PedroCGD earned 2000 total points
ID: 35426340

Expert Comment

by:Kalyanum Deepak Kumar
ID: 35426759
Yes the sole purpose of SSIS configurations is to make the package function with respect to different environemnts without having to modify it frequently. This gives more information to you http://msdn.microsoft.com/en-us/library/ms141682.aspx. I have been working in SSIS for quite some time( 4 years)  using these configurations . ANy hlpe needed , post the issues.

Expert Comment

by:Kalyanum Deepak Kumar
ID: 35426900
Also, need to consider the security for the configuration files . The configuration files can be secured in a folder and the folder can be encrypted using the security features in windows. (sorry have been working for past 5 years for SQL Server 2000,2005,20082008R2 ).
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35430713
Configuration package is for pass parameter to package from outside the scope of package.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question