SQL Server Performance

"The Lookup transformation failed to retrieve any rows."

Discussion in 'SQL Server 2005 Integration Services' started by null, Feb 26, 2009.

  1. null New Member

    Guys and Gals,
    I have an SSIS package that processes a Slowly Changing Dimension. My source data is provided by an Ole Db Source operation that executes a stored procedure. I ran the stored procedure to verify it returns rows and it does. The Ole Db Source then feeds it's records to a Slowly Changing Dimension operation. However, when that begins, my package errors out, citing the message:
    "The Lookup transformation failed to retrieve any rows."
    Why is this happening? Is simply toggling the setting "FailOnLookupFailure" for the SCD the fix? My main concern is why the SCD can't see the records that the Ole Db Source is finding?

Share This Page