SSIS lookup a table with multiple business conditions -


i need lookup against table different business conditions on each column:

  1. against first column "natural" lookup (equal).

  2. against second column, lookup : if match, give me result, if don't match, select rows empty fields.

  3. same thing 3th, 4th, 5th column , 1 row, , 6th column of row matching value need

my question how implement logic against lookup table different business conditions on each column. should implement store procedure?

i see no reason stored procedure. implement in sql query used lookup.


Comments

Post a Comment