I am having a problem getting the named pipes TPT to complete. It appears to take several checkpoints and runs for a while (i am trying to copy apprx 18M rows). It appears to be hanging and the target table is 'being loaded' when I try to get a row count. Any ideas are welcomed....
In your script, you must have indicated that you wanted to use 3 instances of the DataConnector operator.
If you are using an access module, you can only use one instance of the DataConnector operator.
As for the issues, please let me know where the data is coming from.
It looks like you might be using named pipes in the job.
Are you using the Named Pipe Access Module?
If I understand the job a little more, perhaps I can assist.