Post reply

Use variable in query

  • January 27, 2009 at 8:56 am

    #127598

    Hi, can I use a variable inside a query as column?

    Is it possible? How?

    Thanks.

  • January 27, 2009 at 9:49 am

    #933316

    Helical Johan (1/27/2009)

    Hi, can I use a variable inside a query as column?

    Is it possible? How?

    Thanks.

    If you use "Execute SQL Task", setup your SQLSourceType to be Variable. Specify the variable you use to be setup by expression. You make your variable to be evaluated as expression by modifying the variable properties. Make EvaluateAsExpression to True. And then setup your expression. Give it a try and let us know how it goes.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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