The Data Flow tab
One of the most useful and powerful tasks in Control Flow is Data Flow Task. The importance of this task is mostly because it functions as the major part of ETL, which extracts data from different sources, transforms it, and loads it into the destination. As this task plays an important role in an SSIS package and in real-world scenarios, there are few packages that don't contain Data Flow task; SSDT has a special designer for Data Flow, and the SSIS toolbox's items are different in the Data Flow designer.
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
