Post reply

Programmatically changing connection manager settings?

  • January 12, 2009 at 10:44 am

    #129055

    We have a number of packages, stored in MSDB. All these use a datasource in the IP address format, eg 123.4.5.6\InstanceName. Apparently all our IPs will be changing soon, and so we need to change the datasources to ServerName\InstanceName.

    Is there a way to programmatically change these? I've done this for Sql2k DTS packages (via sp_OASetProperty) - I suppose the same method would work in Sql2k5? Or is there a better, niftier, Sql2005-specific way to go about this?

    If anyone can point me in the right direction, I would very much appreciate it. I'm not having much joy with google, I expect I'm not googling for the right terms...

    Thanks

    Maria

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • January 12, 2009 at 11:03 am

    #925421

    The best way would be use config files to store the connection string.

    http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

    HTH

  • January 13, 2009 at 3:11 am

    #925736

    Thanks Mukti

    That does seem the way to go for new SSIS packages... however I was hoping to find a way to retorspectively change the ones we currently have, without having to manually going into each one.

    Any pointers would be greatly appreciated.

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

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

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