Both instances run under the same account

Good tip. Thanks.

Colin

Great reply, lots to think about. Much appreciated

Colin

True, but if your source server no longer exists then you have a problem.

That suggests that in a fast changing environment thatyou must daily script out logins, Jobs, DTS etc in order to maintain a D.R. solution. Hardly efficient.:-)

Understood. But if that server bursts into flames.......

That, thankfully, is not the case. We are trying out various D.R. scenarios.

Thanks. Supose I was naive to think that there may be a list. So how do people find out about them?

My problem was originally put in a posting of...

Craig,

Thank you. All is cear again after a weekend away! Thanks for your help and my issue is resolved.

Colin

I have moved the truncate command to outside the Sequence Box and it now seems to be working as required.

Great to chat and thanks for your time.

Colin

Thanks. Issue could be that truncate command does not go through the log file and therefore cannot be part of a transaction.

There are 3 more steps to include until I...

Here is a screenshot. You can see that the first SQL (Truncate) works, but it then hangs on the first data Flow task.

Colin

The issue is still outstanding.

Posts seem to go before I finish writing them! Sorry about that.

Any help in this area would be gratefully received.

Thanks

Colin

Hi,

Thanks, found it. Must have had the wrong glasses on that day!

Colin

Not sure what happened there, but just wanted to say thanks for any suggestions that people may have.

Cheers

Colin