DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains several tasks that must repeat until an expression evaluates to FALSE.
You need to add and configure a container to enable this design.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order,)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data from a
Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored
procedure has only the @CustomerID parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored
procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter?
(To answer, drag the appropriate option or options to the correct location or locations in the answer
area.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that loads data into a data
warehouse hosted on Windows Azure SQL Database.
You must combine two data sources together by using the ProductID column to provide complete
details for each record. The data retrieved from each data source is sorted in ascending order by the
ProductID column.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of
transformations to the correct location in the answer area.)

You are deploying a new SQL Server Integration Services (SSIS) package to several servers.The package must meet the following requirements:
• .NET Common Language Runtime (CLR) integration in SQL Server must not be
enabled.
• The Connection Managers used in the package must be configurable without
editing the package.
• The deployment procedure must be automated as much as possible.
You need to set up a deployment strategy that meets the requirements.
What should you do?

You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server Agent
job is used to execute a package daily with the basic logging level.
Recently, the package execution failed because of a primary key violation when the package inserted
data into the destination table.
You need to identify all previous times that the package execution failed because of a primary key
violation.
What should you do?

You are developing a SQL Server Integration Services (SSIS) package to load data into a Windows Azure
SQL Database database. The package consists of several data flow tasks.
The package has the following auditing requirements:
 If a data flow task fails, a Transact-SQL (T-SQL) script must be executed.
 The T-SQL script must be executed only once per data flow task that
fails, regardless of the nature of the error.
You need to ensure that auditing is configured to meet these requirements.
What should you do?

You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data
to a Windows Azure SQL Database database.
An automated process must validate all related Environment references, parameter data types, package
references, and referenced assemblies. The automated process must run on a regular schedule.You need to establish the automated validation process by using the least amount of administrative
effort.
What should you do?

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment
Model. All packages in the project must log custom messages.
You need to produce reports that combine the custom log messages with the system-generated log
messages. What should you do?

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data
load strategy. The package reads data from a source system that uses the SQL Server change data
capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source
system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update,
and delete operations.
Which data flow transformation should you use?

A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL
Server table named Transaction. Each file corresponds to a different store and is imported in parallel
with the other files. The data flow tasks use OLE DB destinations in fast load data access mode.
The number of daily transactions per store can be very large and is growing. The Transaction table does
not have any indexes.
You need to minimize the package execution time.
What should you do?