Hi John,
Thanks for your time to reply. 
In above code, I missed important source field "Source_ID" that will tell where the batch start and ends.

John, I was trying to accomplish through SSIS, because my source is .txt. I am not very good in SQL that's the reason I asked for help or show me the right path.

Thank You!