You implement a SQL Server 2008 Integration Services (SSIS) package.
The package contains the following components:
A data flow task contained in a For Loop container
A Flat File destination component that uses a Flat File connection manager
An OnError event handler
When an error occurs in the package, you plan to write diagnostic information from an
expression that includes the version of the package to a text file.
You need to ensure that the required information is written to the text file.
What should you do?

You modify a SQL Server 2008 Integration Services (SSIS) package.
The package extracts data from a text file and loads this data to a SQL Server 2008 table as
shown in the following two exhibits.

You need to update the package to extract data from multiple text files of the same directory.
Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts
data from two sources. Each source database is located on a different server. Each source
is based on a SELECT statement that uses an ORDER BY clause. The data flow is as
shown in the following diagram.

When the paths from the two sources are connected to a Merge Join component, the
following error message is displayed:
“Data Flow Task: The input is not sorted. The ‘input “Merge Join Left Input” (80)’ must be
sorted.”
You need to ensure that data from each query is included in each row in the data flow. You
want to achieve this goal by using minimum amount of execution time.
What should you do?

You are developing a SQL Server 2008 Integration Services (SSIS) package.
The package uses an OLE DB connection manager to connect to a third-party database
server.
The database does not support Integrated Windows authentication.
You create an XML configuration file that provides configuration for the connection manager.
You add the configuration file to the package.
When the package executes, you receive an error message which indicates that login failure
occurred.
You need to execute the package successfully.
What should you do?

You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list
of customers by using a List control. For each customer in the List control, you plan to
include a table that contains the orders for that customer. The customer data is stored in the
Customers table in the data source, and the order data is stored in the Orders table. You
need to define the required dataset or datasets for this report. What should you do?

You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains a table.
You need to ensure that alternate rows in the table have a pale green background.
Which code segment should you use for each text box?

You develop a SQL Server 2008 Reporting Services (SSRS) report.
A Multidimensional Expressions (MDX) query used in the report contains a parameter to
display sales data for various product categories. You write the following query.

You discover that the query generates an error when executed.
You need to ensure that the query executes successfully.
What should you do?

You design a report by using SQL Server 2008 Reporting Services (SSRS).
The report uses a Table data region and contains a dataset. The dataset has a column
named LastName.
You need to ensure that the report items are grouped by the first character in the LastName
column.
Which expression in the Group properties dialog box should you use?

You create a report in SQL Server 2008 Reporting Services (SSRS) solution. You write the
following code segment in the report.

The code segment generates errors when compiled.
You need to ensure that the following requirements are met:
The code segment compiles successfully.
The GetCmFromInches function can be called from other reports.
What should you do?

You develop a SQL Server 2008 Reporting Services (SSRS) solution.
You add a report that contains a single dataset and a query parameter.
You need to ensure that the report executes without user interaction from the Report
Manager.
What should you do?