Thank you HanShi
Looking into your solution too.

You guys...

Hi MMartin1,

I will definitely work with the code and let you know of anything!

Thanks so much for doing this. I really appreciate it.

Cheers

Romina

Hi there,

Just thought of giving you a bit of an update.

I have then worked on the custom SCD and have also found out about a little tweak you can do...

Oh, and I should also mention, I was doing the SCD with the EeNum and the FacID as business keys.

Hi folks,

I sincerely want to thank you first for taking the time to try to help me! Your help is much appreciated!

Ok, since my last post I have gone and...

Phil Parkin (8/20/2014)

---

Koen has already provided a link to an article which he wrote which demonstrates how to do this without using the SCD component. I think that you...

MMartin1 (8/20/2014)

---

Hi Romina,

Are you still using the looping? I don't think that will help. Just use a SCD transform and select it as a 'Historical Attribute' for the change type...

MMartin1 (8/19/2014)

---

I understood you are loading the records from another system. Why not stage the records locally (on your local server) and perform your needed operations there while moving from...

Koen Verbeeck (8/20/2014)

---

Do you have any control on the process that inserts the data into the staging table?

Anyway, 4 million rows is not that much for SQL Server. A...

Thanks Koen and Phil,

I haven't got too far with this. Still struggling to load the data. I am not sure what else to do. It's getting to my nerves.

Any other...

4 and 9

Koen, thank you for this. Very helpful!

In the custom implementation example, is that a Merge or a Merge Join?

If it's simply a Merge, can I use the Union All instead?

In...

Phil,

I am using the SCD wizard from SSIS 2005. Mostly Type 2 changes with very few Type 1.

What I am trying to achieve is retrieve all 4 million records from...

Hi Phil,

Thank you for your reply.

I am not sure I get you when you say a set based approach.

I was just really trying to minimize the number of records entering...