• Put a dataflow on the control flow. Add an OLE DB source and an OLE DB Destination. Done.

    (you can find stuff like this in even the most basic tutorial on SSIS. Did you do any research?)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP