Scheduled Job Error

I am having an issue with a dts package.
I am able to execute the package as myself from enterprise manager but
I recieve an error when running it as a scheduled job. I have read
http://support.microsoft.com/kb/269074/en-us and am either missing
something (highly likly) or it doesn't apply to my particular set of
circumstances.
The dts task uses a "Text File (destination)" Object with a unc path in
its properties
\\remoteserver\d$\nested\folder\input.txt
The job is owned by SA and is executed by our domains sql account
\\mydomain\sqlservice
\\mydomain\sqlservice has been set up with identical permission as
\\mydomain\myaccount to \\remoteserver\d$\nested\folder\
>From the header of the package logs
Executed as user:
MYDOMAIN\sqlservice.
...Start: DTSStep_DTSExecuteSQLTask_1
SQL Task 1 runs just fine (import routines which massage data from
\\anotherserver\inputdir)
Then as soon as it tries to export the file it fails.
DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
(80004005)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp Help co...
Process Exit Code 1.
The step failed.
Seems like a cut and dried case of permissions - but
\\MYDOMAIN\sqlservice has access to the location.
ARRRG! Please advise.
Maxmake sure that your sql server agent is running. Look under the management
folder in IE and it should have a green arrow in front of it, if it had a red
square it is not running.
--
Paul G
Software engineer.
"xamfear@.comcast.net" wrote:
> I am having an issue with a dts package.
> I am able to execute the package as myself from enterprise manager but
> I recieve an error when running it as a scheduled job. I have read
> http://support.microsoft.com/kb/269074/en-us and am either missing
> something (highly likly) or it doesn't apply to my particular set of
> circumstances.
> The dts task uses a "Text File (destination)" Object with a unc path in
> its properties
> \\remoteserver\d$\nested\folder\input.txt
> The job is owned by SA and is executed by our domains sql account
> \\mydomain\sqlservice
> \\mydomain\sqlservice has been set up with identical permission as
> \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> >From the header of the package logs
> Executed as user:
> MYDOMAIN\sqlservice.
> ...Start: DTSStep_DTSExecuteSQLTask_1
> SQL Task 1 runs just fine (import routines which massage data from
> \\anotherserver\inputdir)
> Then as soon as it tries to export the file it fails.
> DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> (80004005)
> Error string: Error opening datafile: Access is denied.
> Error source: Microsoft Data Transformation Services Flat File Rowset
> Provider
> Help file: DTSFFile.hlp Help co...
> Process Exit Code 1.
> The step failed.
> Seems like a cut and dried case of permissions - but
> \\MYDOMAIN\sqlservice has access to the location.
> ARRRG! Please advise.
> Max
>|||look under the management folder in Enterprise manager, not IE as I specified
below.
--
Paul G
Software engineer.
"Paul" wrote:
> make sure that your sql server agent is running. Look under the management
> folder in IE and it should have a green arrow in front of it, if it had a red
> square it is not running.
> --
> Paul G
> Software engineer.
>
> "xamfear@.comcast.net" wrote:
> > I am having an issue with a dts package.
> > I am able to execute the package as myself from enterprise manager but
> > I recieve an error when running it as a scheduled job. I have read
> > http://support.microsoft.com/kb/269074/en-us and am either missing
> > something (highly likly) or it doesn't apply to my particular set of
> > circumstances.
> >
> > The dts task uses a "Text File (destination)" Object with a unc path in
> > its properties
> > \\remoteserver\d$\nested\folder\input.txt
> >
> > The job is owned by SA and is executed by our domains sql account
> > \\mydomain\sqlservice
> >
> > \\mydomain\sqlservice has been set up with identical permission as
> > \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> >
> > >From the header of the package logs
> > Executed as user:
> > MYDOMAIN\sqlservice.
> > ...Start: DTSStep_DTSExecuteSQLTask_1
> >
> > SQL Task 1 runs just fine (import routines which massage data from
> > \\anotherserver\inputdir)
> > Then as soon as it tries to export the file it fails.
> >
> > DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> > (80004005)
> > Error string: Error opening datafile: Access is denied.
> > Error source: Microsoft Data Transformation Services Flat File Rowset
> > Provider
> > Help file: DTSFFile.hlp Help co...
> > Process Exit Code 1.
> > The step failed.
> >
> > Seems like a cut and dried case of permissions - but
> > \\MYDOMAIN\sqlservice has access to the location.
> >
> > ARRRG! Please advise.
> > Max
> >
> >|||Thanks for taking the time to reply Paul. The agent is running, and we
know it runs fine since other jobs are run as the agent just fine, and
in this case the other steps of the Job execute fine as well.
Thanks
Max
Paul wrote:
> look under the management folder in Enterprise manager, not IE as I specified
> below.
> --
> Paul G
> Software engineer.
>
> "Paul" wrote:
> > make sure that your sql server agent is running. Look under the management
> > folder in IE and it should have a green arrow in front of it, if it had a red
> > square it is not running.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "xamfear@.comcast.net" wrote:
> >
> > > I am having an issue with a dts package.
> > > I am able to execute the package as myself from enterprise manager but
> > > I recieve an error when running it as a scheduled job. I have read
> > > http://support.microsoft.com/kb/269074/en-us and am either missing
> > > something (highly likly) or it doesn't apply to my particular set of
> > > circumstances.
> > >
> > > The dts task uses a "Text File (destination)" Object with a unc path in
> > > its properties
> > > \\remoteserver\d$\nested\folder\input.txt
> > >
> > > The job is owned by SA and is executed by our domains sql account
> > > \\mydomain\sqlservice
> > >
> > > \\mydomain\sqlservice has been set up with identical permission as
> > > \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> > >
> > > >From the header of the package logs
> > > Executed as user:
> > > MYDOMAIN\sqlservice.
> > > ...Start: DTSStep_DTSExecuteSQLTask_1
> > >
> > > SQL Task 1 runs just fine (import routines which massage data from
> > > \\anotherserver\inputdir)
> > > Then as soon as it tries to export the file it fails.
> > >
> > > DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> > > (80004005)
> > > Error string: Error opening datafile: Access is denied.
> > > Error source: Microsoft Data Transformation Services Flat File Rowset
> > > Provider
> > > Help file: DTSFFile.hlp Help co...
> > > Process Exit Code 1.
> > > The step failed.
> > >
> > > Seems like a cut and dried case of permissions - but
> > > \\MYDOMAIN\sqlservice has access to the location.
> > >
> > > ARRRG! Please advise.
> > > Max
> > >
> > >|||ok, not sure off hand what the problem is, hopefully someone will respond
shortly.
--
Paul G
Software engineer.
"xamfear@.comcast.net" wrote:
> Thanks for taking the time to reply Paul. The agent is running, and we
> know it runs fine since other jobs are run as the agent just fine, and
> in this case the other steps of the Job execute fine as well.
> Thanks
> Max
> Paul wrote:
> > look under the management folder in Enterprise manager, not IE as I specified
> > below.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Paul" wrote:
> >
> > > make sure that your sql server agent is running. Look under the management
> > > folder in IE and it should have a green arrow in front of it, if it had a red
> > > square it is not running.
> > > --
> > > Paul G
> > > Software engineer.
> > >
> > >
> > > "xamfear@.comcast.net" wrote:
> > >
> > > > I am having an issue with a dts package.
> > > > I am able to execute the package as myself from enterprise manager but
> > > > I recieve an error when running it as a scheduled job. I have read
> > > > http://support.microsoft.com/kb/269074/en-us and am either missing
> > > > something (highly likly) or it doesn't apply to my particular set of
> > > > circumstances.
> > > >
> > > > The dts task uses a "Text File (destination)" Object with a unc path in
> > > > its properties
> > > > \\remoteserver\d$\nested\folder\input.txt
> > > >
> > > > The job is owned by SA and is executed by our domains sql account
> > > > \\mydomain\sqlservice
> > > >
> > > > \\mydomain\sqlservice has been set up with identical permission as
> > > > \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> > > >
> > > > >From the header of the package logs
> > > > Executed as user:
> > > > MYDOMAIN\sqlservice.
> > > > ...Start: DTSStep_DTSExecuteSQLTask_1
> > > >
> > > > SQL Task 1 runs just fine (import routines which massage data from
> > > > \\anotherserver\inputdir)
> > > > Then as soon as it tries to export the file it fails.
> > > >
> > > > DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> > > > (80004005)
> > > > Error string: Error opening datafile: Access is denied.
> > > > Error source: Microsoft Data Transformation Services Flat File Rowset
> > > > Provider
> > > > Help file: DTSFFile.hlp Help co...
> > > > Process Exit Code 1.
> > > > The step failed.
> > > >
> > > > Seems like a cut and dried case of permissions - but
> > > > \\MYDOMAIN\sqlservice has access to the location.
> > > >
> > > > ARRRG! Please advise.
> > > > Max
> > > >
> > > >
>|||That is a permissions error. Is the SQL Agent service
account also running under the domain account? The way you
have this set up, the SQL Agent service account would need
to be an administrator on the remote server - if it's not
then that's probably the issue.
Try creating a share on the remote server and give the SQL
Agent service account full permissions to this share. Then
reference the share you just created instead of the Admin
share you referenced using for the file location.
-Sue
On 29 Aug 2006 14:09:39 -0700, xamfear@.comcast.net wrote:
>I am having an issue with a dts package.
>I am able to execute the package as myself from enterprise manager but
>I recieve an error when running it as a scheduled job. I have read
>http://support.microsoft.com/kb/269074/en-us and am either missing
>something (highly likly) or it doesn't apply to my particular set of
>circumstances.
>The dts task uses a "Text File (destination)" Object with a unc path in
>its properties
>\\remoteserver\d$\nested\folder\input.txt
>The job is owned by SA and is executed by our domains sql account
>\\mydomain\sqlservice
>\\mydomain\sqlservice has been set up with identical permission as
>\\mydomain\myaccount to \\remoteserver\d$\nested\folder\
>>From the header of the package logs
>Executed as user:
> MYDOMAIN\sqlservice.
> ...Start: DTSStep_DTSExecuteSQLTask_1
>SQL Task 1 runs just fine (import routines which massage data from
>\\anotherserver\inputdir)
>Then as soon as it tries to export the file it fails.
> DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
>(80004005)
> Error string: Error opening datafile: Access is denied.
> Error source: Microsoft Data Transformation Services Flat File Rowset
>Provider
> Help file: DTSFFile.hlp Help co...
> Process Exit Code 1.
> The step failed.
>Seems like a cut and dried case of permissions - but
>\\MYDOMAIN\sqlservice has access to the location.
>ARRRG! Please advise.
>Max