Where does the package execution begin?

HOTSPOT
You are working as an ETL developer for a payroll company. You configure a SQL Server
2008 Integration Services (SSIS) package to use checkpoints.
The SSIS package truncates the dbo.Employee_Attendance table, loads the new employees
in the dbo.Employee table, and then loads dbo.Employee_Attendance for a particular month.
The package fails at the Derived Column transformation within the data flow task.
You need to determine where the package execution will begin after you correct the errors
and run the package again.
Where does the package execution begin? (To answer, select the appropriate task in the
control flow.)

HOTSPOT
You are working as an ETL developer for a payroll company. You configure a SQL Server
2008 Integration Services (SSIS) package to use checkpoints.
The SSIS package truncates the dbo.Employee_Attendance table, loads the new employees
in the dbo.Employee table, and then loads dbo.Employee_Attendance for a particular month.
The package fails at the Derived Column transformation within the data flow task.
You need to determine where the package execution will begin after you correct the errors
and run the package again.
Where does the package execution begin? (To answer, select the appropriate task in the
control flow.)

Answer:

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *