Posted by Erland Sommarskog on 05/04/07 21:40

Connie (csawyer@rwbaird.com) writes:
> I am getting the following info on failure:
> Executed as user: US\svcsqlserver. ...Move /Y F:\NPPDFs\*.* \\Mil-
> Pegasus-01\Optical\NaviplanOptical001\F:\NPPDFs\8562.pdfF:\NPPDFs
> \8830.pdfF:\NPPDFs\8869.pdfF:\NPPDFs\8955.pdfF:\NPPDFs\8961.pdfF:
> \NPPDFs\8968.pdfF:\NPPDFs\9019.pdfF:\NPPDFs\9023.pdfF:\NPPDFs
> \9024.pdfF:\NPPDFs\9025.pdfF:\NPPDFs\9027.pdfF:\NPPDFs\9028.pdfF:
> \NPPDFs\9031.pdfF:\NPPDFs\9034.pdfF:\NPPDFs\9036.pdfF:\NPPDFs
> \9041.pdfF:\NPPDFs\9042.pdfF:\NPPDFs\9043.pdfF:\NPPDFs\9044.pdfF:
> \NPPDFs\9047.pdfF:\NPPDFs\9055.pdfF:\NPPDFs\9056.pdfF:\NPPDFs
> \9057.pdfF:\NPPDFs\9058.pdfThe specified network name is no longer
> available.The specified network name is no longer available.The
> specified network name is no longer available.F:\NPPDFs\9070.pdfF:
> \NPPDFs\9073.pdfF:\NPPDFs\9077.pdfF:\NPPDFs\9079.pdfF:\NPPDFs
> \9081.pdf 29 file(s) moved. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSCreate... Process Exit Code 1. The step failed.
>
> When I check our optical storage I see the pdf's above have been moved
> there, so my issues is what is actually failing? If anyone has any
> ideas I would greatly appreciate it :) If step 1 is failing then the
> above PDF files would not be there to move so it must be succeeding,
> I am just not sure what else to look at.
>

I guess it's the "The specified network name is no longer available."
Seems like there was a glitch when the share disappeared for a short
while. If you can verify that all files are where they should be, I guess
you can sleep well.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]