none
SSIS - VARIABLES - FOR EACH

    Dotaz

  • I have two tables that populate variables:

    STATE populates StateList(Object)/ThisStateID(string) and Product populates ProductCode(Object)/ThisProdCodeID(string)

    I want to use a FOR EACH LOOP with ForEachADO Enumerator to process a record set once for each state/product code combination.  50 states/4 prod codes

    SELECT ID
    FROM xxx.table
    WHERE state_abr = ?
    AND prod_cd =?

    Works well with one variable - but not two...have not found any instructions on the internet for such a scenario - but this shouldn't be hard.  Can anyone advise?

    14. června 2018 15:39

Všechny reakce