You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages.The new capability is not available as an SSIS task. Each package must be extended with the same new capability.You need to add the new capability to all the packages without copying the code between packages.What should you do?
DRAG DROP -A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse.The SSIS catalog includes two Environments:✑ Test✑ ProductionEach Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the test or production data warehouses.You need to execute deployed packages by using either of the defined Environments.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.)Select and Place:
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Microsoft Azure SQL Database database. The package has been deployed to a 64-bit production SQL Server.The package fails when executed on the production server.You need to ensure that the package can load the 32-bit Excel workbook data without errors.What should you do?
HOTSPOT -You are editing a SQL Server Integration Services (SSIS) package.You need to edit the Script task that has an expression defined.Which task should you select? To answer, select the appropriate setting or settings in the answer area.Hot Area:
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on SQLAzure. One of the columns in the data source is named ProductCode.Some of the data to be loaded will reference products that need special processing logic in the data flow.You need to enable separate processing streams for a subset of rows based on the source product code.Which data flow transformation should you use?
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?
