April 7, 2005 at 1:13 pm
I've moved my DTS from one MS SQL SERVER to another SQL Server. Before I've moved my DTS ran very well on the old server. But now on the new SQL Server, the package doesn't run very well. I do not have any error messages. It just executes forever. However,The package runs fine when I disable two options in Workflow Properties wizard:
- Join transaction if present, and
- Rollback transaction on failure.
However These options are enabled on my client's server and my old server and I had no problems.
I do not understand the difference.
Any idea?
Thanks.
April 8, 2005 at 6:03 am
I think this may have to do with the MSDTC service running (or rather not running) on your client's server. Check if it is running and start it if it is not and see if that helps.
HTH.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply