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
Raunak Jhawar
SSCoach
Points: 15701
More actions
August 16, 2010 at 11:51 am
#1207504
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....
Raunak J