MS SQL Server - SQL Server Job Failing, but DTS Package Runs

Author

SQL Server Job Failing, but DTS Package Runs - HELP!!!

ATLDBA

2006-03-29, 11:23 am

I have created a DTS package that transfers data from an Access database in a
network share to an internal development SQL Server database. The package
executes successfully, but when I create a job to run daily @ 1am. It fails
when I try to run the job. My domain account is the owner of the job. I have
even changed the job owner to "sa", but to no avail.

Here is a copy of my errors from the Job History:

& #91;AviationWebPages
].[dbo].[CIP_Current] Step, Error = -2147467259 (80004005)
Error string: 'W:\TransportationDa
ta-Planning- Intermodal\Intermoda
l\...
Process Exit Code 5. The step failed.

Do you have any suggestions?
Any assistance is greatly appreciated.
Thanks
--
"Minds are like parachutes; they work best when open."

-Thomas Dewar

Tore Hansen

2006-03-29, 8:23 pm

The SQL Server agent service must run with an account witch has access to
the file.
Not the Local system account.

Tore...

"ATLDBA" <ATLDBA@discussions.microsoft.com> skrev i melding
news:69DE3113-0B10-4303-84B5- 261FB69BFA08@microso
ft.com...
>I have created a DTS package that transfers data from an Access database in
>a
> network share to an internal development SQL Server database. The package
> executes successfully, but when I create a job to run daily @ 1am. It
> fails
> when I try to run the job. My domain account is the owner of the job. I
> have
> even changed the job owner to "sa", but to no avail.
>
> Here is a copy of my errors from the Job History:
>
> & #91;AviationWebPages
].[dbo].[CIP_Current] Step, Error = -2147467259
> (80004005)
> Error string:
> 'W:\TransportationDa
ta-Planning- Intermodal\Intermoda
l\...
> Process Exit Code 5. The step failed.
>
> Do you have any suggestions?
> Any assistance is greatly appreciated.
> Thanks
> --
> "Minds are like parachutes; they work best when open."
>
> -Thomas Dewar
>

ATLDBA

2006-03-29, 8:23 pm

Thanks. I just checked, and the SQL Service Agent service account does have
access to the network file, but it still does not work.

ATLDBA

--
"Minds are like parachutes; they work best when open."

-Thomas Dewar

"Tore Hansen" wrote:

> The SQL Server agent service must run with an account witch has access to
> the file.
> Not the Local system account.
>
> Tore...
>
>
> "ATLDBA" <ATLDBA@discussions.microsoft.com> skrev i melding
> news:69DE3113-0B10-4303-84B5- 261FB69BFA08@microso
ft.com...
>
>
>

Sue Hoegemeier

2006-03-31, 3:23 am

Try using a UNC path - it looks like you are going at a file
on a mapped drive. Service accounts need UNC paths as they
aren't profile specific.

-Sue

On Wed, 29 Mar 2006 11:53:03 -0800, ATLDBA
<ATLDBA@discussions.microsoft.com> wrote:

>Thanks. I just checked, and the SQL Service Agent service account does have
>access to the network file, but it still does not work.
>
>ATLDBA

ATLDBA

2006-04-03, 8:23 pm

Thanks Sue. That was the problem. I was using a mapped drive path in the
DTS Package It still seems odd that the package would, but the job would not.

Thanks again.
--
"Minds are like parachutes; they work best when open."

-Thomas Dewar

"Sue Hoegemeier" wrote:

> Try using a UNC path - it looks like you are going at a file
> on a mapped drive. Service accounts need UNC paths as they
> aren't profile specific.
>
> -Sue
>
> On Wed, 29 Mar 2006 11:53:03 -0800, ATLDBA
> <ATLDBA@discussions.microsoft.com> wrote:
>
>
>

Sponsored Links