You are a database administrator for an e-commerce company that runs an online store. The company has the databases described in the following table.
Each day, you publish a Microsoft Excel workbook that contains a list of product names and current prices to an external website. Suppliers update pricing information in the workbook. Each supplier saves the workbook with a unique name.
Each night, the Products table is deleted and refreshed from MDS by using a Microsoft SQL Server Integration
Services (SSIS) package. All files must be loaded in sequence.
You need to add a data flow in an SSIS package to perform the Excel files import in the data warehouse.
What should you use? package that uses the Excel Source and the SQL Server Destination in the data flow.
A.
Lookup transformation
B.
Merge transformation
C.
Merge Join transformation
D.
MERGE statement
E.
Union All transformation
F.
Balanced Data Distributor transformation
G.
Sequential container
H.
Foreach Loop container
Explanation:
If you’re familiar with SSIS and don’t want to run the SQL Server Import and Export Wizard, create an SSIS
References: https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/import-data-fromexcel-to-sql
