Post reply

RetainSameConnection question

  • March 30, 2010 at 7:30 am

    #146244

    Hi,

    I'm wondering if it is best practice to set the RetainSameConnection property to True. We're loading a data warehouse and we have three connections (JDE_BusinessData, JDE_ODS & DataWarehouse).

    We're using control packages to call other packages that call other packages, sort of a cascading approach. If we set the DataWarehouse connection in the ETL_Control.dtsx package will it pass this down to the subordinate packages?

    Also, are there any pit falls to setting this to RetainSameConnection = True?

    Any words of wisdom would be greatly appreciated.

    Thanks,

  • March 30, 2010 at 8:58 am

    #1142306

    I don't believe connections are retained package-to-package only intra-package. I am personally not aware of issues. However, I usually leave it off. The new connection isn't that big of a deal.

    CEWII

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

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