You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD). You need to add a task or component to the package that allows you to implement the SCD logic. What should you use?
A. a Data Conversion component
B. an Execute SQL task that executes a MERGE statement on the database