You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three ExecuteSQL tasks have their TransactionOption property set to Supported.You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes.What should you do?
DRAG DROP -You are developing a SQL Server Integration Services (SSIS) package.The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language IntegratedQuery (LINQ).You need to ensure that the LINQ code can be debugged at design time.What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)Select and Place:
DRAG DROP -You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B.Both packages must reference a file path corresponding to an input folder where files will be located for further processing.You need to design a solution so that the file path can be easily configured with the least administrative and development effort.Which four 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.)Select and Place:
You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD).You need to add a task or component to the package that allows you to implement the SCD logic.What should you use?
DRAG DROP -You develop a SQL Server Integration Services (SSIS) project by using the Project Deployment model.The project contains many packages. It is deployed on a server named Development1. The project will be deployed to several servers that run SQL Server 2012.The project accepts one required parameter. The data type of the parameter is a string.A SQL Agent job is created that will call the master.dtsx package in the project. A job step is created for the SSIS package.The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter.You need to configure SSIS on the Development1 server to pass the Environment Variable to the package.Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence DevelopmentStudio (BIDS).The package includes custom scripts that must be upgraded.You need to upgrade the package to SQL Server 2012.Which tool should you use?
