You design a Business Intelligence (BI) solution by using SQL Server 2008. You are responsible for the migration of a database from Microsoft SQL Server 2000 to SQL Server 2008. You want to identify the potential data quality problems before migration. You plan to design a solution by using SQL Server 2008 Integration Services (SSIS). You need to ensure that the solution meets the following requirements:

Runs as a repetitive process based on SSIS.

Allows specification of flexible patterns to identify NULL and

invalid column values.

Requires minimum development efforts.

Which SSIS task should you use?

Question

You design a Business Intelligence (BI) solution by using SQL Server 2008. You are responsible for the migration of a database from Microsoft SQL Server 2000 to SQL Server 2008. You want to identify the potential data quality problems before migration. You plan to design a solution by using SQL Server 2008 Integration Services (SSIS). You need to ensure that the solution meets the following requirements:

Runs as a repetitive process based on SSIS.
Allows specification of flexible patterns to identify NULL and

invalid column values.

Requires minimum development efforts.

Which SSIS task should you use?

Accepted Answer

B. Data Profiling

Answer

A. Script

Answer

C. ActiveX Script

Answer

D. Data Mining Query

You design a Business Intelligence (BI) solution by using SQL Server 2008. You are responsible for the migration of a database from Microsoft SQL Server 2000 to SQL Server 2008. You want to identify…

Question

Options

How the community answered

Community Discussion