Post reply

Using variables in a Lookup transformation

  • May 14, 2009 at 11:16 am

    #130101

    How do pass variables to a sql statement in a lookup transform?

    I have a package that I'm putting together... and at the beginning of the package I load up several variables with values from a table... then later in the package, I want to do use a lookup transform, where I lookup some records in another table based on one of the variables that I populated previously... I may be missing something obvious here, but how do I set this up?

  • May 15, 2009 at 12:51 pm

    #995591

    bmturney (5/14/2009)

    How do pass variables to a sql statement in a lookup transform?

    I have a package that I'm putting together... and at the beginning of the package I load up several variables with values from a table... then later in the package, I want to do use a lookup transform, where I lookup some records in another table based on one of the variables that I populated previously... I may be missing something obvious here, but how do I set this up?

    This is duplicate post. The question is being answered here.

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

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

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