PrepAway - Latest Free Exam Questions & Answers

Which control flow logic should you implement?

You design a SQL Server 2008 Integration Services (SSIS) package. The package extracts
data from flat files and loads this data to a SQL Server 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 on holidays, the @IsHoliday variable is set to True. You need to implement the
following business logic in the control flow of the package:
When the ©IsWeekday variable is set to True, the Perform Weekday Processing Data Flow
task is executed.
When the ©IsWeekday variable is set to False, the Perform Weekend Processing Data Flow
task is executed.
When the @IsHoliday variable is set to True, the Perform Holiday Processing Data Flow task
is executed.
Which control flow logic should you implement?

PrepAway - Latest Free Exam Questions & Answers

A.

B.

C.

D.


Leave a Reply