Hi all, thanks for the advice.
I have gone with Thoms suggestion and it's working very nicely.
I am having an additional issue with importing the data due to differing...

Many thanks, I will let you now how I get on.

Dave

Hi Phil, thanks for the reply. I presume if I schedule it for say 3 am every day, it will simply restart at that time each day?
Dave

Well thanks for enlightening me to my character flaws so eloquently and for confirming that I know no more about SQL than a 2 year old.

If you had taken the...

Hi sorry security prohibits me sharing anything further I am afraid. I appreciate that without it, you will not be able to assist. Thanks for your time.

Dave

Hi, good point re the package store.

He is setting me up a service account ( as he controls the AD on that domain) and then setting me RDP access...

Hi, thanks for clarifying. I am getting RDP access arranged in the next couple of weeks. Sadly the DBA who controls all of this has never used SSIS and prefers...