MSBI Tutor

QUESTION 1 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 vender data and has approximately 1000 records. The OLE source contains loan data and has approximately 1,000,000 records. Sample vendor data (Excel source) is shown in the following table: VendorID VendorName 1 VendorA 2 VendorB 3 VendorC 4 VendorD 5 VendorE Sample loan data (OLE DB source) is shown in the following table: LoanNumber VendorID LoanAmount I-100 1 120000 I-200 1 130000 I-300 2 150000 I-400 3 150000 I-500 4 160000 I-600 4 170000 I-700 5 180000 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)