Post reply

ssis shared connection manager between packages

  • January 29, 2013 at 8:33 am

    #394054

    Hi

    In SQL Server 2008 is there a way of sharing a connection manager in the same project between packages.

    Thanks in advance

  • January 29, 2013 at 8:48 am

    #1582181

    Not exactly, You can create a project level Data Source, then in the connection Managers you can use the New Connection From Data Source option

    this will inherit the settings from the project level package ,except that changes to the project level data source will not be reflected in the packages so you would have to go and change the specifics within individial packages.

    Thanksfully this has changed in SSIS 2012

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • January 29, 2013 at 8:50 am

    #1582183

    thankfully indeed

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

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