nerdexam
Microsoft

70-448 · Question #85

You are changing a SQL Server 2008 Integration Services (SSIS) instance which get information from a doc file and loads this information to a SQL Server 2008 table for Company.com. The information…

The correct answer is A. You should increase a parameter to the package. C. You should increase a Foreach Loop container to the package. F. You should increase an expression to the Flat File connection manager. See the full explanation below for the reasoning.

Question

You are changing a SQL Server 2008 Integration Services (SSIS) instance which get information from a doc file and loads this information to a SQL Server 2008 table for Company.com. The information is listed below:

You should make sure that you could modify the instance to get data from many text files of the same directory. Which is the correct answer? (Select more than one)

Exhibit

70-448 question #85 exhibit

Options

  • AYou should increase a parameter to the package.
  • BYou should increase a parameter to the data flow task.
  • CYou should increase a Foreach Loop container to the package.
  • DYou should increase a While container to the package.
  • EYou should increase some expressions to the Flat File Source component.
  • FYou should increase an expression to the Flat File connection manager.

How the community answered

(36 responses)
  • A
    81% (29)
  • B
    3% (1)
  • D
    6% (2)
  • E
    11% (4)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice