You are designing a SQL Server Integration Services (SSIS) package that will load data from a source system
to a data mart.
You need to combine conditionally the value of two project parameters to a package variable.
What should you do?
You have a data warehouse that contains all of the sales data for your company. The data warehouse contains
several SQL Server Integration Services (SSIS) packages.
You need to create a custom report that contains the total number of rows processed in the package and the
time required for each package to execute.
Which view should you include in the report?
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
Your company has a data mart that contains customer review data.
The customer reviews are of the product review or service review type.
You plan to load each customer review type to a separate fact table.
You create a SQL Server Integration Services (SSIS) package as shown in the exhibit. (Click the Exhibit
button.)
You need to modify the package to load the customer review data to the new fact tables. The SSIS package
must contain a single data flow.
What should you do?
You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an
HTML web page that lists product stock levels.
You need to implement a data flow task that reads the product stock levels from the HTML web page.
What should you do?