Post reply

Pass Variable values in Lookup transformation

  • March 23, 2011 at 9:40 pm

    #234521

    Hi All

    I have variable name SDO=(DIN or VDI)

    In lookup transformation i am using the query

    select distinct item_id from [EFeed.DIN.Prep.Item_Detail] where attribute_id in ('F103D50E-4BA8-4E72-9AA2-712DB72049B0','631B277B-0A89-4147-9C50-438741674DE0')

    In above sql script if SDO=DIN then table name should be [EFeed.DIN.Prep.Item_Detail]

    and if SDO=VDI then table name should be [EFeed.VDI.Prep.Item_Detail]

    [The above variable values are passing dynamically during package run]

    Thanks

    Rohit

  • March 24, 2011 at 1:43 am

    #1302809

    I don't have SSIS in front of me, but I'm 99% sure you can load the SQL Statement as an expression. Build out your dynamic query in the expression builder.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

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

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