You are developing a SQL Server Integration Services (SSIS) package.The package is stored as the myPackage.dtsx file in the root directory of the C drive of the SSIS server.You need to run the package from the command prompt.Which command should you use?
HOTSPOT -You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools.A package Connection Manager has been parameterized with project scope.You need to display the parameters that have been generated for the Connection Manager.What should you use? To answer, select the appropriate setting or settings in the answer area.Hot Area:
You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred.You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts.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 implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a Microsoft Azure SQL Database database into a data warehouse.The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis.You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum.What should you do?
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night.The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.The current setting for the Fuzzy Lookup similarity threshold is 0.50.Many values are incorrectly matched.You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.What should you do?
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?
