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.)Select and Place:
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.)Select and Place:
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?
Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series.Information and details provided in a question apply only to that question.You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Microsoft Azure SQL 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?
