While using the SSIS data flow, we can perform ETL task that can be used for data migration, data offloading, design and implementation of the data warehouse.
In this article, I explain how to export data from an SQL table to excel and text file by using the SSIS data flow task.
In this demo, I will perform through the following steps:
1. Create an SSIS package and create ADO.NET connection manager.
2. Create data flow task that has ADO.NET source to populate data from SQL Server. Data will be written to excel file and text file hence configure flat file destination and excel destination.
3. Execute SSIS package and verify that data was written to excel and text files.