Hi,

I created a DTS package wich runs a standard Stored Procedure in the master
database.

De stored procedure is called sp_makewebtask and it creates an HTML file
with a grid of the data you query.

I call the stored procedure by an Execute SQL Task object with all necesarry
parameters filled in.

It lools like this:

EXECUTE sp_makewebtask @outputfile = N'D:\outputlog\output.htm',
@query
= N'SELECT *
FROM ip_log
WHERE (MONTH(timestamp) = MONTH(GETDATE())) AND (YEAR(timestamp) =
YEAR(GETDATE()))',
@fixedfont = 1, @HTMLheader = 3,
@webpagetitle = N'IP Log Service Pages Visits', @resultstitle = N'Logged
IPs',
@URL = N'http://www.motifact.nl', @reftext = N'http://www.motifact.nl',
@dbname = N'dbase_01', @whentype = 1, @nrowsperpage = 10,
@procname = N'IP Log', @codepage = 65001, @charset
= N'utf-8'

When I log on as administrator on the server and run the package manually it
works fine. If I run it as a scheduled job it fails and produces the next
messages:

Step 0 (Job outcome )

The job failed. The Job was invoked by User DBSERVER-01\Administrator. The
last step to run was step 1 (IP Log Export).

Step 1 (Execute SQL Task (IP Log Export))

Executed as user: DBSERVER-01\SYSTEM. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
Error string: SQL Web Assistant: Could not execute the SQL statement.
Error source: Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0 Error Detail Records: Error: -2147217900
(80040E14); Provider Error: 16805 (41A5) Error string: SQL Web
Assistant: Could not execute the SQL statement. Error source:
Microsoft OLE DB Provider for SQL Server Help file: Help
context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun:
Package execution complete. Process Exit Code 1. The step failed.

I think it has something to do with acount rights. The agent logs in with
the local system account.

Can anyone help me on this one.

thanks in advance.

René de Leeuw

Have a look at this article

http://support.microsoft.com/?kbid=269074

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"René de Leeuw" <rene.de.leeuw (AT) motifact (DOT) nl> wrote