Problem with dtutil hanging

I am using a script to copy a number of packages (50+) from my desktop computer (file system) to a remote server (MSDB). The script works fine, but I can never get through the entire script without it hanging up. Some times only 3-4 packages get copied, sometimes a lot more. If I close the windows cmd window and restart at the point it hung, it continues, but usually hangs up again. If you repeat this 2 or 3 times, it eventually gets all of the packages copied. It does not always hang at the same point. I have tried doing the copies with "quiet" mode - overwriting the existing packages and I have tried first deleting the packages, then copying - doesn't make a difference. I have also tried moving the packages to a couple of different installations of SQL Server 2005 using the script - the remote one and the local one on my desktop - same thing on both.

If I have the script echo a message just after each copy, the message just after the last successful copy never appears (and I know the copy is successful, because I deleted all the packages first and have checked that the package is there after the script hangs).

The copy command I am using look like this:

dtutil /FILE %1 /Decrypt %3 /Encrypt SQL;%~n1;2;%3 /DestServer %4 /DestUser admincis /DestPassword %2 /quiet
ECHO Done deploying package %~n1

%1 is the file spec of the ".dtsx" file to be copied

%2 is the password of the user account on the server

%3 is the encryption password (same one used on both ends)

%4 is the name of the server being copied to

Any ideas?

Jane Gaby

One addition to my original post. I just tried this from a different computer - copied the .dtsx files over and the scripts and ran from there with no problem - no hangup. The computer I used was another server, not a desktop. Anyway it looks like the problem is perhaps with my desktop.

Jane Gaby

Problem with DTS

Hi,
I was wondering if anyone has ever had this problem before.
I have a whole host of DTS packages that are executed from one DTS package.
The DTS packages essentially get data from a Sybase database and puts the
data into a text file, runs a simple Stored proc which etc, nothing really
complicated.
Problem is lately when I run the DTS package which is called from a Batch
file which is executed by scheduler, random packages seem to go into a
continuous loop and the package continues to insert data into the text file
until such time as my server runs out of space.
Any ideas anyone.
Thanks
KNever seen that problem.
Do you have the tasks set to "Close connection on completion"
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Kathy Bezuidenhout" <Kathy.Bezuidenhout@.nospam.aig.com> wrote in message
news:ab2cnTWLr4q05gqiU-KYjQ@.is.co.za...
> Hi,
> I was wondering if anyone has ever had this problem before.
> I have a whole host of DTS packages that are executed from one DTS
package.
> The DTS packages essentially get data from a Sybase database and puts the
> data into a text file, runs a simple Stored proc which etc, nothing
really
> complicated.
> Problem is lately when I run the DTS package which is called from a Batch
> file which is executed by scheduler, random packages seem to go into a
> continuous loop and the package continues to insert data into the text
file
> until such time as my server runs out of space.
> Any ideas anyone.
> Thanks
> K
>