1. File System Task
2. Execute SQL Task (SQL) or Execute Process Task (batch)
3. Data Flow with corresponding sources and destinations.
4. Send Mail Task
The SSIS development team really did their best to choose logical names for the components 😉
ActiveX --> Script Task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP