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:01 pm

    #857021

    You can create a variable e.g. sQuery. In the script task you make this variable writable (specify it in the ReadWriteVariables field) and then set the value of this variable in the script

    Dts.Variables("sQuery").Value = "select....". Later on, you can set the expression for the SqlStatementSource to execute this query @[User::sQuery] . Hope that answers your question.