"Microsoft introduced Azure Data Factory as an ETL tool for the Azure platform. They introduced a large number of tasks that you can set up. But the most basic task, that of transforming data has not been possible without dumping the data to an intermediate structure. Until now…
In this session, we will look at the Microsoft’s Data Flow feature, which is currently in preview. We will look at how you can transform your data using components almost the same as SSIS data flow transformations.
I will finally demonstrate how you can handle fixed width text files using Data Flows. I will demonstrate how to generate the fixed width data flow from metadata stored in Excel or SQL Server."
Presented by: Russ Loski