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.
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.
0
0
C
0
0