Hi

With out sounding negative, let me share my experience.

Currently I'm running VS2005 8.0.5 no serice pack and net 2.0 sp 2. I had all the latest service packs installed...

Now this I did't know. I very knew you could do this!

But I'm quite sure that this should be done with great care as well!

Hi

Have you had a look at the "FTP Task" and "Send Email Task" in the SSIS Control Flow?

CozyRoc (11/26/2008)

---

Your problem is not that only one CPU is used. Your problem is that you use OLEDB destination component. This is the slowest possible way to insert. What is...

I was looking at the Bulk Insert Task which is found on the Control Flow. Got it now, will see what is the difference

Hi...

Hi Tim

Just to add, I've also experienced various problems with copying of components and specially the script component. I've re-installed VS on my PC about 4 times in the past...

Thanks for the reply Cozyroc

It is from a the same SQL Server 2005 machine, just from 1 DB to another DB (both sql 2005). I've never used Bulk insert task...

Thanks Micheal

Makes sense in what you are saying, but I do think that I should try the parallel approach.

My script component actually does quite a bit of processing seeing that...

Add a script component to your code to do the convertion.

In my script component I've added a reference to a dot net program that i wrote which basically checks for...