You are an ETL developer for a mortgage company. In your application you have to load
data from a Microsoft Excel source and an OLE DB source.
The Excel source contains vendor data and has approximately 1000 records.
The OLE DB source contains loan data and has approximately 1,000,000 records.
Sample vendor data (Excel source) is shown in the following table:
Sample loan data (OLE DB source) is shown in the following table:
The CIO asks you to generate an Excel file with the loan list information for each vendor.
You build a SQL Server 2008 Integration Services (SSIS) package that can generate the
Excel files dynamically. The Excel files should have the vendor name as the prefix and the
date as the suffix (e.g., VendorA_DDMMYYYY.xlsx).
You get the error message shown in the exhibit. (Click the Exhibit button.)
You need to sort both sources in order to merge join the data.
What should you do?
A.
Sort the data in the select statement of the OLE DB source and use Sort transformation
after the Excel source.
B.
Set the IsSorted property to True for OLE DB, sort the data in the select statement of the
OLE DB source, and use Sort transformation after the Excel source.
C.
Set the IsSorted property to True for both the OLE DB and Excel sources.
D.
Use Sort transformation after the OLE DB source and set the IsSorted property to True
for the Excel destination.