February 13, 2008 at 10:21 am
Hi,
I have created a package that has an exexute SQL task and 3 Data Flow tasks all inside a sequnce container.
The Sequnce container is set to begin a transaction.
I run this package from my local workstation.
The package gets data from a server with a SQL 2005 Server database and writes to another Server SQL 2000 server.
- MSDTC is running on my workstation and both servers set to
- allow Network DTC Access,
- allowing inbound and outboand with
- No Authentication
The transaction successfully starts and the first task(execute SQL task - which deletes some records from the SQL 2000 server) completes
The Package then appears to hang on the data flow task. Viewing the progress pane. It would seem to get stuck at the validation sticking at 57%.
Has anyone any experience of data flow tasks via DTC, that might be able to shed any light on this?
February 19, 2008 at 8:54 am
I've managed to resolve this, it seemed to be down to a lack of indexes on one of the queries
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply