Post reply

Using one Config across the Master and child packages..

  • April 15, 2011 at 12:49 am

    #249042

    I have one master packages and three child packages.. each package makes a databse conneciton and do some processing.

    I am executing the child packages in the Master. for datbase connection I have created a db connection with name db_Connection in all four packages( 1 master and 3 child)

    I am using the same confing file for all 4 packages.. does that case any problem.in prduction.? my concers is why I have to create db connection in each packages with same name > is that the correct way ? any other way ?

  • April 15, 2011 at 2:16 am

    #1311972

    chetanb3 (4/15/2011)

    I have one master packages and three child packages.. each package makes a databse conneciton and do some processing.

    I am executing the child packages in the Master. for datbase connection I have created a db connection with name db_Connection in all four packages( 1 master and 3 child)

    I am using the same confing file for all 4 packages.. does that case any problem.in prduction.? my concers is why I have to create db connection in each packages with same name > is that the correct way ? any other way ?

    I don't see a problem with that approach. If the names are consistent and you use the same config file, there should be no issues.

    Another approach is that you use only the config file for the master package and that you configure the child packages through parent configurations.

    But I would go for your approach 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 15, 2011 at 2:30 am

    #1311982

    Thanks.:-)..

    I have another question, If I add the log provider as text file for master package..will that be ok.. I mean the file will contain log from child packages.. also

  • April 15, 2011 at 2:35 am

    #1311986

    chetanb3 (4/15/2011)

    Thanks.:-)..

    I have another question, If I add the log provider as text file for master package..will that be ok.. I mean the file will contain log from child packages.. also

    Normally the errors from the child package will propagate to the master package.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply