Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Configuration Expand / Collapse
Posted Monday, June 17, 2013 4:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 25, 2014 4:37 AM
Points: 36, Visits: 122
Hi ,

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.
Post #1464079
Posted Tuesday, June 18, 2013 8:44 AM


Group: General Forum Members
Last Login: Saturday, September 17, 2016 8:01 AM
Points: 2,834, Visits: 2,629
One parent package with a For Each loop that gathers all the appropriate configuration parameter values and passes them to a single child package that takes the configuration parameter values and does the actual load work. If you can't figure out how to make a single child package do all the work, you can use several child packages and call the appropriate one based on the configuration parameter values.
Post #1464700
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse