I have around 50 Entities.Where in for each entity I have around 6-20 Packges .In each package Iam calling a configuration Script Where all the parameters for the Procedures ,DB Connections are configured.
So no of configuration scripts =40[No of Entities] * 6[No of Packges]=240 Times (mininum)
Where in I have to run all these 40 entities to 7 countries .
For every country I have a seperate DB .Connection to DB is Fetched Using Package Name
.Through this Packge Name there is a global table where we fetch data for each country.
So I need to rename all 240 Packges for evry country .For All this entities we wil Create Seperate Jobs for
each of country in SQL Agent .
Its too cumbersome.Kindly request you to provide an alternative solution to avoid this renaming of packages and config script calls and easy deployment.