Link to home
Start Free TrialLog in
Avatar of SeTech
SeTechFlag for United States of America

asked on

SSIS Configuration

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.
ASKER CERTIFIED SOLUTION
Avatar of PedroCGD
PedroCGD
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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 ).
Avatar of Alpesh Patel
Configuration package is for pass parameter to package from outside the scope of package.