SSIS Interview Questions and Answers | What is SSIS Configurations Table

TechBrothersIT
TechBrothersIT
30.6 هزار بار بازدید - 10 سال پیش - In this video you will
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
http://sqlage.blogspot.com/search/lab...
10 سال پیش در تاریخ 1393/10/11 منتشر شده است.
30,659 بـار بازدید شده
... بیشتر