You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts data from flat files and loads this data to a SQLServer 2008 database.
The package contains two Boolean variables named @IsWeekday and @IsHoliday.
When the package is executed on week days, the @IsWeekday variable is set to True.
When the package is executed onholidays, the @IsHoliday variable is set toTrue.
You need to implement the following business logic in the control flow of the package:
– When the @IsWeekday variable is set to True, the PerformWeekday Processing Data Flow task is executed.
– When the @IsWeekday variable is set to False, thePerformWeekend Processing Data Flow task is executed.
– When the @IsHoliday variable is set toTrue, the Perform Holiday Processing Data Flow task is executed.
Which control flow logic should you implement? (Exhibit)
A.
B.
C.
D.
