Hi
I have an SSIS script task that builds up a variable that is a SQL server statement. I need ot be able to execute that statement in the script task.

Here is the code I have

        Dim oCnn As New Data.SqlClient.SqlConnection
        Dim sSQL As String
        Dim sSQLUpdate As String
        Dim AccountNumber As String
        Dim Nov_07 As String
        Dim Sep_07 As String
        oCnn.ConnectionString = "Data Source=localhost;Initial Catalog=PAY_HISTORY"
        Dim oCmd As SqlCommand = New SqlCommand

        sSQL = "SELECT AccountNumber, Sep_07, Nov_07 FROM PAY_HISTORY_Data_temp "
        sSQL += "WHERE (AccountNumber  IN  (SELECT AccountNumber  FROM  PAY_HISTORY_History)) "
        oCmd.CommandText = sSQL
        oCmd.Connection = oCnn
        oCnn.Open()
        Dim oReader As SqlDataReader = oCmd.ExecuteReader()

        While oReader.Read
            AccountNumber = oReader.Item("AccountNumber").ToString
            Nov_07 = oReader.Item("Nov_07").ToString
            Sep_07 = oReader.Item("Sep_07").ToString

            sSQLUpdate = "update PAY_HISTORY_History set "
            sSQLUpdate += "Sep_07='" & Sep_07 & "', "
            sSQLUpdate += "Nov_07='" & Nov_07 & "' "
            sSQLUpdate += "Where AccountNumber='" & AccountNumber & "'"          
            '
            '******************* Need to execute the above SQL here
            '

        End While

        oReader.Close()
        oCnn.Close()
Thanks in advanced.

I would be happy to entertain other ways of doing this as well