HOTSPOT
You are an ETL developer for a mortgage company. In your application you have two tables
named Vendor and Loan.
Vendor sample data is shown in the following table:

Loan sample data is shown in the following table:

You need to build a SQL Server 2008 Integration Services (SSIS) package that meets the
following requirements:
The package should be able to generate the Excel files dynamically.

Each file should have the vendor name as the prefix and the date as the suffix (e.g.,
VendorA_DDMMYYYY.xlsx).
All the vendor names should be added to a variable and loop through the variable to
generate and load separate files for each vendor dynamically.
Which type of variable should you create? (To answer, select the appropriate option in the
dialog box in the answer area.)

Answer:

Explanation: