You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package is named UpdateTable.dtsx and contains a variable named runID. The package must run by using the dtexec utility. The runID variable must be set at runtime to a value of 5. You need to meet the outlined requirements. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS)package.The OLE DB

data source for the package is a database that is updated frequently.You need to create a package that

accomplishes the following tasks:

Implement the IRowsetFastLoad interface.Support various data flow destinations. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The package uses at least one sequence container in one transaction. Each transaction controls a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint.

The Control Flow task follows the Success constraint. The package must include the following requirements:

Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.

A restart point must restart each Data Flow task and the Control Flow task that follows it as an atomic unit.

You need to make changes in the control flow designer to meet the outlined requirements.

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

While testing, a Transact-SQL user-defined function causes duplicate key values that stop the transformation.

To permit the transformation to continue, the package must perform the following tasks:

1 Ascertain which rows are affected.
2 Insert the rows that fail into a table.
3 Continue with the process.

You need to change certain properties in the package to meet the requirements.

Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You need to create a package that must meet the following requirements:

It must be transactional. It must be optimized for 20 tables. It must be stored securely in the msdb database of a remote server.

What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package contains 30 Data Flow tasks and 30 Control Flow tasks. The package runs slower than expected. You need to capture the start time, the finish time, and the elapsed time for the validation

and execution of the package. What should you do?

You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.

The package has the following features:

Two Data Flow tasks and two Control Flow tasksA success constraint between each Data Flow task and the subsequent Control Flow task

The package uses one transaction for all the tasks.

You need to configure the package so that the two Data Flow tasks use their own transactions. You also need to ensure that each Control Flow task is enlisted in the same transaction as its preceding Data Flow task.

Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)