thx! I didn't read all 8 pages of the discussion... 🙂

grtz,

NIco

What version is being used?

I'm doing something similar in 2008 version, but it crashes.

Posted a bug report @ microsoft, but still no reply...

grtz,

Nico

Update2:

Replaced the SCD component with 2 lookups.

First lookup is to split records that exist from the ones that are new. (New will be inserted)

Second lookup is to check if...

Update:

I've changed the setup to have 3 source connections:

- One for the fields that need to be loaded without LOOKUP

- One for Lookup one, containing BusinessKey Field(s) and Lookup Fields

-...