SSIS | Data Flow Task | Export Data to Excel from SQL Server Table
Exporting data to the Excel file from the SQL server table | load data to the Excel from SQL table
• SSIS | Data Flow Task | Export Data to Exc...
You can download the table script on the below drive location
https://drive.google.com/drive/folder...
The below are the steps involved to perform this data flow activity
1.Drag and drop the data Flow task
2.Define the Source
Select Source as Table object present in MS SQL Server
3.Define destination
Select Destination as EXCEL Fie by using Excel Connection manager.
4.Run the SSIS Package. So that the data will get load to the destination (EXCEL)
Please click the below for the Playlist. So, you can check all videos posted myself for the SSIS Tutorial
• SSIS real time scenarios examples