SeTech
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.
Is there any other important aspect that one should know about configuration packages.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 ).
Configuration package is for pass parameter to package from outside the scope of package.