1. What is Configuration in SSIS
2. Why we even need configuration
3. What configuration types are available for us to use
4. What is difference between Direct and Indirect Configuration
5. If we use SQL Server Configuration, what table is created by configuration Wizard
6. How many columns configuration table do have, which one are important for us
7. For indirect configuration, do you create user variable or system variable to hold connection string?
8. What is parent child configuration and where we need to use that
9. Explain best practices for Integration Services Configuration
10. Let’s say we have SQL Server Connection Name ‘MyConnection’, when you will enable configuration which properties of Connection manager you will choose (Description,EvaluateAsExpression,Expression,IncludeInDebug,Name,NameSpace,RaiseChangedEvent,ReadOnly,Value)
2. Why we even need configuration
3. What configuration types are available for us to use
4. What is difference between Direct and Indirect Configuration
5. If we use SQL Server Configuration, what table is created by configuration Wizard
6. How many columns configuration table do have, which one are important for us
7. For indirect configuration, do you create user variable or system variable to hold connection string?
8. What is parent child configuration and where we need to use that
9. Explain best practices for Integration Services Configuration
10. Let’s say we have SQL Server Connection Name ‘MyConnection’, when you will enable configuration which properties of Connection manager you will choose (Description,EvaluateAsExpression,Expression,IncludeInDebug,Name,NameSpace,RaiseChangedEvent,ReadOnly,Value)
Awesome Work Vipin
ReplyDelete