CODEWITHSUNDEEP
ssislookup
sagar
sagar

Reputation: 159

Empty lookup table vs non-matching lookup table (lookup transform)

Is empty lookup table the same as non-matching lookup table in lookup transform?

What would be the result if no row redirection is configured?

  1. an empty result set or
  2. package failure at the lookup transform

Upvotes: 0

Views: 703

Answers (1)

Eric
Eric

Reputation: 95123

You could get #2: Package failure. It would not be able to find the row in the lookup table (since it's empty).

Edit: I should say that if you set the Error Configuration to Ignore Failure, you will get an empty rowset.

Upvotes: 1

Related Questions