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.
SeTechAsked:
Who is Participating?
 
PedroCGDCommented:
0
 
Kalyanum Deepak KumarSenior Technical LeadCommented:
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.
0
 
Kalyanum Deepak KumarSenior Technical LeadCommented:
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 ).
0
 
Alpesh PatelAssistant ConsultantCommented:
Configuration package is for pass parameter to package from outside the scope of package.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.