Home Forums SQL Server 2005 SQL Server 2005 Integration Services Dynamically changing Server info for OleDB Connection RE: Dynamically changing Server info for OleDB Connection

  • August 16, 2010 at 12:44 pm

    #1207519

    Raunak Jhawar (8/16/2010)

    Siddharth,

    Foreach with one scipt task and EST. Loop parameters ki value...name of server will change upon some condition....now we have a server name...script task and EST...easy...but remember to set DelayValidation to true....

    Thanks Raunak, this seems like a good idea. I'll try it out.

    -Sid