Hi,

Thanks to all the experts for taking the time to help, I  will try what has been suggested

many thanks again

Hi

The package executes automatically and I have checked all objects to copy..however still get the message

Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'GL_DISTRIBUTION'

I checked both source...

Hi,

I do have the right permissions and have set the log to report the status of the DTS package. I will rerun and see what happens

thanks

Hi Allen,

Tried what you suggested ie setup a new job and scheduled it to run last night, it failed again but this time it did not even write a log to...

Thank you very much again  ....

no doubt I will be in touch soon...

Hi Jesper,

Thanks for your help...its sorted now...apolgoies for my lack of clarity. Im new to this and will aim to be clearer in the future.

many thanks

Hi David,

That did the trick perfectly...

Could you kindly recommend any good books that will allow me to advance my T-SQL skills please?

thanks for your help again

Hi, Thanks for the quick reply. I just noticed that on the original post the table has shitfted the data. it should look like the table below..im only interested in...