Скачать или смотреть 12 - SSIS - Troubleshoot/Debug Data Flows using Data Viewer

This video shows a step by step on how to Troubleshoot/Debug Data Flows using Data Viewer.


Data Viewer – Used between two transformations to see the data. When a package is executed, Data Viewer pop up window shows what is changed from Input to Output.
Data Flow Task - Encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved.

OLE DB Source\Destination – Extracts\Loads data into a variety of OLE DB-compliant databases using a database table or view or an SQL command. 


SSIS is part of the Microsoft SQL Server data software, used for many data migration tasks. It is basically an ETL tool that is part of Microsoft's Business Intelligence Suite and is used mainly to achieve data integration. ... The data warehouse captures data from various sources for useful access and use.

Visit my channel & Subscribe
   / @dmkitsolutions  
See other step by step video series below: -

Introduction to SQL
   • 4 - SQL Server Management Studio (SSMS) In...  

Learn Microsoft Business Intelligence MSBI (SSIS, SSAS, SSRS) in just 10 minutes
   • 1 - Learn Microsoft Business Intelligence ...  

Getting Started with Power BI
   • Getting Started with Power BI  

SSIS - Load data like an Expert (Update Existing Records and Insert New Records)
   • 16 - SSIS : Load data like an Expert (Upda...  

Power BI - Get Data from flat file (csv)
   • Power BI  - Get Data from flat file (csv)  

Microsoft Excel Dashboard
   • How to create Excel Dashboard | Pivot Tabl...  

For more details contact [email protected] or text +1 (858) 228 7289