SSIS Interview Questions and Answers | What is SSIS Configurations Table

In this video you will learn about using SQL Server Configuration Table in SSIS Configuration.

When you enable SQL Server Configuration in SSIS Package, it has to create a table by using wizard with name SSISConfiguraitons. The table have 4 columns. Configuration filter and configured value are the most important columns those we use to store different configuration values for connection managers and variables etc.

The video shows you how to create the SSIS Configuration Table
How to insert configuration value in SSIS Configuration table by using Package configuration
What are the best practices to choose properties for Connection managers, variables etc.

Complete list of SQL Server DBA Interview Questions by Tech Brothers

[krismaly]

This is one of the important practical aspect in configuration.One must watch this video.

[krismaly]

I enjoyed watching and listening this video and recommend others.

Thanks for educating the community and appreciate your volunteership.

Thanks a bunch

[shilpashree]

Thank you so much for sharing these videos. I almost learnt SSIS only by following your videos! Please keep it coming.And let me know if there is any platform where I can ask my doubts and get clarified by you. :)

[parimal]

Hi, I am watching your videos and these are very informative. I have question 
I want to know Is there any smart method to check the tables and stored procedures in ssis packages as now there is requirement in my project to change the values in some place ?

[deva]

in 2012 I dont see package configuration menu what is it changed to? I see parameterize in the bottom which looks something relavent but the ui is entirely different