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?

Question

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?

Accepted Answer

B. Set the IsSorted property to True for OLE DB, sort the data in the select statement of the OLE DB

Answer

A. Sort the data in the select statement of the OLE DB source and use Sort transformation after the

Answer

C. Set the IsSorted property to True for both the OLE DB and Excel sources.

Answer

D. Use Sort transformation after the OLE DB source and set the IsSorted property to True for the Excel

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…

Question

Exhibits

Options

How the community answered

Community Discussion