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 to the way Windows Server 2003 handles memory, and that is to add the /3GB switch to the boot.ini file.

I have done this and things have improved slightly. I can now run around 21,000 records at a time ... woohoo!!! Yes, I know it's pretty sand, considering I have to do nearly 5 million records.

Now the package breaks after 2:45mins of running and it has the following error:

Description: component OLE DB Destination failed the pre-execute phase and returned error code 0x8007000E.

There are no more error messages so it's pretty obscure and I can't seem to find the reason why it would do this after running so well for that long.

Any ideas?