Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to modify sql statement for all Oledb Source from Script Task programmatically RE: How to modify sql statement for all Oledb Source from Script Task programmatically

  • August 12, 2008 at 2:17 pm

    #857036

    While the two suggestions are spot on, you do not need a script task to modify the variable value. Look at variable expressions (Highlight variable, F4). You can make the variable dynamic and do exactly what you are after.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!