You are here: Re: DTS Job Reporting Failures « MsSQL Server « IT news, forums, messages
Re: DTS Job Reporting Failures

Posted by Connie on 05/04/07 22:01

On May 4, 4:40 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Connie (csaw...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -
>
> - Show quoted text -

Thanks Erland I was leaning towards a network issue of some sort I
appreciate the verification.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация