Just curious to know why did you design your package like this ?
I meant you could have used a DFT and then an OLEDB source and destination with bulk insert.There also, you have option to keep identity of source.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂