You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.What should you do?
You are deploying a new SQL Server Integration Services (SSIS) project to the test environment.A package in the project uses a custom task component.You need to ensure that the custom object is deployed on the test environment correctly.What should you do?
Your company has several line-of-business applications. The applications use a server that has SQL Server installed and contains several databases.You need to ensure that the business applications can access curated and validated data from the databases.Which features should you deploy to the server?
To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology.The methodology has the following requirements:✑ Centralized logging in SQL Server✑ Simple deployment✑ Availability of log information through reports or T-SQL✑ Automatic purge of older log entries✑ Configurable log detailsYou need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort.What should you do?
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain.You need to complete the mapping of the Group column.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?
