• SSIS realized the data flow didn't do anything actually useful, so it removed the source and multicast at runtime (you did connect them together, right?). You can avoid this by setting RunInOptimizedMode to false on the data flow.

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