Problem with executing a DTS from a remote machine

[Friso Wiskerke]

Hi all,

We've created a VB.NET application which runs a couple of DTS packages on a
SQL Server in a specific order using ADO.NET. When we runs this application
on the same machine that SQL Server resides on it works fine. However when
we run the application on another machine in the domain the first package is
started but it doesn't finish.

This package is a straightforward one: truncate a table, copy records
(approx. 10.000.000) from one database table into the table which has just
been truncated and finally create a couple of indexes. This step takes about
30 min. to complete. When we run it from a remote machine we can see that
the table has been truncated however there are no records copied into it.

When we look in the Proces Info in SQL Server the proces which is running
the package has a status of: wait and as command: NETWORKIO. The wait time
increases gradually.

Does anybody know what the problem could be?

TIA,
Friso Wiskerke

[Cor Ligthert [MVP]]

Friso,

In your place would I ask this question as well in the newsgroup.

microsoft.public.dotnet.framework.adonet

There are some persons active who really like dts.

I hope this helps anyhow

Cor