Explain why variables called the most powerful component of SSIS?
Variable 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 a fixed value for the query parameter. In such scenarios, we can use variables and refer the variable to the query parameter. We can use variables for like:
- Updating the properties at runtime,
- Populating the query parameter value at runtime,
- used in a script task,
- Error handling logic and
- with various looping logic.
Comments
Post a Comment