Post reply

expression for sql command in data flow task

  • November 11, 2013 at 9:01 am

    #279977

    I have a data flow task with two OleDB connections, one for the source and one for the destination. I used to be able to build the SQL command for the source SQL using an expression, but now the SQL command is not in the list of available expressions and I cannot figure out why. Any help is appreciated.

  • November 11, 2013 at 9:26 am

    #1665516

    Isn't "Query from variable" or something like that one of the options? If you choose that, you can build the value of the variable with an expression and set that variable to be the query that runs for your source.

    John

  • November 11, 2013 at 9:48 am

    #1665524

    I figured out I can use a parameter in the Source OleDB connection but I am still perplexed as to why the SQL Command is not an option in the expression builder.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply