Thankyou very much Sir, for helping me out. I really appreciate.
So, here is what I did.
I introduced one new column in your inputFile1.txt namely A2
I then insert a new record in 'tempTableMapping' as
I also introduced new column in destination table i.e 'TempTable' for new incoming column as.
But as you see your package run fine but it didn't mapped the new incoming column.
Here is what I did on coding side.
I updated the value of MAPPING_COUNT to 7, as extra column is added in temp table. But, updating CreateNewOutputRows() produced errors like this
Which I believe is because the corresponding code for new column is not produced at runtime which was supposed to be as per documentation.
For just confirmation if the RecordSet is getting all the values, I debugged the code and found that variable was fine holding all the mappings.
As you see.
I know I am missing something but couldn't figure out yet. Please Help me out of this I shall be thankful to you as this is the only Solution I can find online to achieve dynamic behavior. I am sorry, I have not much understanding of VB, so, couldn't tell much in technical terms as I am from web Development background.
And Thank-you so much for your precious time,