Скачать или смотреть SSIS Tutorial Part 115-Read Status Flag From Table & Control SSIS Package Flow(Single Row ResultSet)

SSIS Tutorial Demo Scenario:

The company we work has multiple processes running every night. After completing all of the process a Flag it set to YES,No Or Pending in SQL Server Table. We need to create an SSIS Package that read this flag value and then Run Required Tasks according to the flag value that is stored in SQL Server Table.

Items we will leaven in this video

How to Create SQL Table with Flag Column
How to create Variable in SSIS Package to hold Flag Value
How to save Flag value into Variable by using Execute SQL Task ( Result Set Single Row)
How to use Precedence Constraint in SSIS Package to Control the Flow of Tasks Executions
Find out If expressions in Precedence Constraint are Case Sensitive or Not in SSIS Package

Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/04/ho...