Home Forums Data Warehousing Integration Services Find out the not matching key value in look up RE: Find out the not matching key value in look up

  • August 22, 2017 at 10:45 am

    #1956209

    Phil Parkin - Tuesday, August 22, 2017 10:24 AM

    Charmer - Tuesday, August 22, 2017 9:55 AM

    Hi Phil, 

    It's already redirected.  But now they want to do this on the go.  They want to remove look up and use script component and identify the miss match key values.

    What do you mean by 'on the go'?

    I mean at the time of when the data flow is executed.  I have been instructed to Replace lookup with script component and find out the reason of non matched rows and process the matched rows.

    Thanks,
    Charmer