SQL Server – SSIS – Debugging – Exploring the Data Viewer

Geschrieben von Database Magician am Dienstag, 28. Februar 2017

'I often get questions regarding debugging of SSIS packages with the most common scenario being a need to “see” the data flowing down the data pipeline. SQL Server Integration Services (SSIS) packages are explored and edited visually within the SQL Server Data Tools (SSDT) and hence, the mechanism to troubleshoot an SSIS package when developing it also has to be visual.

The Data Viewer allows a developer to pause the data flow in a data flow task and look at the data as it is on that point in the pipeline. Today, I will introduce you to the Data Viewer.'...

https://nakulvachhrajani.com/2017/01/23/0399-sql-server-ssis-debugging-exploring-the-data-viewer/