Which tool should you use?

You are developing a SQL Server Integration Services (SSIS) package that loads data from a source
transactional tables in a data warehouse.
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?

You are developing a SQL Server Integration Services (SSIS) package that loads data from a source
transactional tables in a data warehouse.
You discover that one of the data flows loads incorrect data to one of the destination tables.
You need to identify the cause of the incorrect data flow. Which tool should you use?

A.
SSIS logging.

B.
a breakpoint

C.
a data viewer

D.
the locals window.

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

jml

jml

Correct

https://msdn.microsoft.com/en-us/library/ms137944.aspx

Microsoft Integration Services and the SSIS Designer include features and tools that you can use to troubleshoot the data flows in an Integration Services package.
SSIS Designer provides data viewers.
SSIS Designer and Integration Services transformations provide row counts.
SSIS Designer provides progress reporting at run time.

Reply