none
Problem with Look up transformation in ssis 2005 with FullCache

    Question

  • My problem is as follows. The task is to join records from two tables by using the Lookup component.
    The records that are already in the target table are transferred to a txt file and those that are new thrown into the target table.
    With a small number of records (in the target table) 100 000 everything works fine and when the target table is already include 200000, result is as follows "Lookup has cached 190 000 rows" and nothing happens.
    The process is suspended and SSIS Lookup component does not perform. With Partial or None option, the situation is very similar. Lookup processing a number of records and then stops without error message

    please help me
    Sunday, December 30, 2012 10:57 AM

Answers

  • you can do some debugging to find out where is the issue exactly, for example;

    you can change query to lookup table in Lookup transform to just get small number of records from lookup table to see how it works.

    or/and you can add data viewers to data paths to see is data coming out of lookup component or not

    ...


    http://www.rad.pasfu.com

    • Marked as answer by Eileen Zhao Monday, January 07, 2013 8:50 AM
    Sunday, December 30, 2012 9:47 PM

All replies

  • what do you mean by suspending the process?

    do you mean that component will be in yellow color and doesn't complete? could you explain more or put screenshot of your data flow on that execution state?


    http://www.rad.pasfu.com


    Sunday, December 30, 2012 11:11 AM
  • Hii,

    This threads might be helpful to u ..

    http://www.simple-talk.com/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/

    http://msdn.microsoft.com/en-us/library/ms141821.aspx

    Thanks,

    Satish


    satti

    Sunday, December 30, 2012 11:12 AM
  • what do you mean by suspending the process?

    do you mean that component will be in yellow color and doesn't complete? could you explain more or put screenshot of your data flow on that execution state?


    http://www.rad.pasfu.com


    component is white but control flow is yellow

    Sunday, December 30, 2012 11:42 AM
  • what do you mean by suspending the process?

    do you mean that component will be in yellow color and doesn't complete? could you explain more or put screenshot of your data flow on that execution state?


    http://www.rad.pasfu.com



    Sunday, December 30, 2012 11:43 AM
  • do you get anything loaded into EMAIL DUPLICATE destination? (I mean after execution)

    http://www.rad.pasfu.com

    Sunday, December 30, 2012 12:03 PM
  • EMAIL DUPLICATE  is empty. I think that cached process stop and SSIS not run but I don't now why.
    Sunday, December 30, 2012 12:14 PM
  • component EMAIL DUPLICATE is green in control flow but file isn't create
    Sunday, December 30, 2012 12:21 PM
  • you can do some debugging to find out where is the issue exactly, for example;

    you can change query to lookup table in Lookup transform to just get small number of records from lookup table to see how it works.

    or/and you can add data viewers to data paths to see is data coming out of lookup component or not

    ...


    http://www.rad.pasfu.com

    • Marked as answer by Eileen Zhao Monday, January 07, 2013 8:50 AM
    Sunday, December 30, 2012 9:47 PM