mcfarlandparkway (10/14/2016)
Is there any example or link should I refer to?I am confused here ..If you have any proper links where I can see and implement please forward it to me.
What I think John is suggesting is
a) That your config file contains the 10 connection strings
b) That you configure your connection to the source database (in the package) to use a variable.
c) That you put a FOR loop in your package which sets the above variable to the values for connstr1, connstr2 etc. each time it loops.
d) Put your data flow inside the FOR loop.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.