Thanks so much for that URL. I'm still trying to get to grips with connection strings, and there are all the examples one could ever want! 😎

Thanks so much for that URL. I'm still trying to get to grips with connection strings, and there are all the examples one could ever want!

[Sorry about the DUP,...

Just to close this, in case anyone else has a similar problem and wants a solution - yes it is because of NULLs in the data. I now know...

Thinking about this overnight, I wonder if the problems is caused by NULLs in the data? (If that IS the reason, why does SSIS produce such a vague error...

Yes I see, that would be the best way to do it. I was focusing on the data flow and didn't think about deleting the about-to-be replaced data BEFORE...

It'll be DELETE ... WHERE rather than DROP or TRUNCATE, as I don't want to lose other data in the table, from other sources. At the moment there are...

Thanks for the quick and helpful replies. So SSIS It is then!

David