Getting error in Lookup Transformation in SSIS

  • Hi All,

    Iam getting an error in Lookup transformation when iam truncating the lookup reference table. the package failed at the lookup if the reference table does not have the data.

    if we load the data in reference table then the package is executing successfully.

    can anybody help in this regard.

    Thanks in advance

    sathish

  • Perhaps I missed something in your post, but are you asking why a lookup fails if there is no data in the lookup table?

    By default, if a value is not found during a lookup operation (your data flow has ID "1" but it is not in the lookup table) a lookup component will fail. You can configure the error output of the lookup to ignore failures. If you do this, not finding the record will result in returning NULL.

  • Thanks michel,

    Actually, i would like to insert what are the rows the source table have and does not have the destination and also changed rows in the source table in to the destination by using conditional split transformation after the Lookup.

    in this regard iam getting error.

    any suggestions pls

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

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