Explain why variables called the most powerful component of SSIS?
Submitted by: AdministratorVariable allows us to dynamically control the package at runtime. Example: You have some custom code or script that determines the query parameter's value. Now, we cannot have fixed value for query parameter. In such scenarios, we can use variables and refer the variable to query parameter. We can use variables for like:
1. updating the properties at runtime,
2. populating the query parameter value at runtime,
3. used in script task,
4. Error handling logic and
5. With various looping logic.
Submitted by: Administrator
1. updating the properties at runtime,
2. populating the query parameter value at runtime,
3. used in script task,
4. Error handling logic and
5. With various looping logic.
Submitted by: Administrator
Read Online SSIS Job Interview Questions And Answers
Top SSIS Questions
☺ | Explain why variables called the most powerful component of SSIS? |
☺ | Explain the use of containers in SSIS and also their types? |
☺ | Explain Error Handling in SSIS? |
☺ | What is precedence constraint? |
☺ | Can we add our custom code in SSIS? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |