Yes, all are going to the same table but the different batch. 
Any other better advice to accomplish this?

Hi Frederico,
Thank you for your time to comment. I am sure you already read "it is a SAMPLE data".  The client is sending the data from "SalesForce" system.

Is someone can help me to write a code to add "RankID" column in my source file?

Sample Source Data

March 3, 2018 at 4:54 pm

#1981863

If I can add "RANKID" in my source then I can easily Pull my data through above While Loop. Here is source table as an example.

RankID,Source_id,sta_id    ,Address1 ,City    ,PaymentMethod,Invoice_Detail
1     ...

Sorry If I confuse you. Yes, first I said my source is SQL and yes the original source is my .txt. I thought it is easy for me to load...

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...

This question has been answered. Thank You for your reply!

Phil, 

Thank You for your reply, It will solve this issue that I am having. However, If I have data with extra, it will break the process that is...

Thanks Drew. It works.

Thanks for your help and sorry for not providing a full Info. 
First of all, I created a sample data and sample scenario. 

Thomas, Thank You for your reply. That I know I can do those things and I am doing for some reports. However, The question was how I am able to...

sgmunson sorry, if my question is not clear. I thought it is...

Guys Appreciate your thoughts. 

I am not sure how can I accomplish to transfer dumps file into Oracle through SSIS and execute package through batchIs file or DTEXECUI. Is...

That is exactly what I am looking. Tomorrow I will run above code in the Live data and give you update. Looks good to me. 

Thank You.

Awesome! That's what I need. 

Thank You for your help!

--*******This Question is answered by Chris*************