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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

do you get anything loaded into EMAIL DUPLICATE destination? (I mean after execution)

---

http://www.rad.pasfu.com

Answer 6

EMAIL DUPLICATE  is empty. I think that cached process stop and SSIS not run but I don't now why.

Answer 7

component EMAIL DUPLICATE is green in control flow but file isn't create

Answer 8

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