You design a Business Intelligence （BI） solution by usi

单项选择题

You design a Business Intelligence （BI） solution by using SQL Server 2008.
You need to load data into your online transaction processing （OLTP） database once a week by using data from a flat file. The file contains all the details about new employees who joined your company last week. The data must be loaded into the tables shown in the exhibit. （Click the Exhibit button.） Employee.EmployeeID is an identity. The safer ，easier way to help you pass any IT exams.
A SQL Server 2008 Integration Services （SSIS） package contains one data flow for each of the destination tables. In the Employee Data Flow， an OLE DB Command transformation executes a stored procedure that loads the Employee record and returns the EmployeeID value.
You need to accomplish the following tasks：
Ensure that the EmployeeID is used as a foreign key （FK） in all child tables for the correct Employee record.
Minimize the number of round trips to the database.
Ensure that the package performs in the most efficient manner possible. What should you do？（）

A. Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.
B. Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.
C. After the Employee table is loaded， write the data to a Raw File Destination and use the raw file as a source for each of the subsequent Data Flows.
D. After the Employee table is loaded， write the data to a Flat File Destination and use the flat file as a source for each of the subsequent Data Flows.

MCTS(70-452)