Usage of SQL Server configuration
SQL Server configuration is more useful whenever it is required to store the multiple parameters in the SSIS configuration.
Implementing the SQL Server configuration -
Let's create a simple and short implementation of SQL Server package configuration.It will store the variable value in a SQL server table and later we will check it at the package level.
Step 1 - Open SQL server Business Intelligence Development Studio and create a new Integration Services Project -
Step 14 - Now run the same SSIS package, it should populate a message box with the same variable value which is edited at Step 11.
As per the above screen shot we are getting the same value which was stored previously at Step 11. SQL Server configuration has been completed successfully.
I hope this article will help you to understand on how to implement SQL Server configuration in a
Please feel free to share your comments/suggestions.