Groups | Blog | Home
all groups > sql server dts > february 2004 >

sql server dts : anyone pls help



haseeb
2/27/2004 9:10:34 AM
Hi all,
Sql server 7.0

I am using web assistant job to display some data on web
page which refreshes every 1 min.
the jobs running fine but when i checked event viewer of
application logs, i found the below error
Error: 16821, Severity: 16, State: 1
2004-02-27 07:37:02.70 ods .
Operating system error 87., The parameter is incorrect.
when i checked the job throughly i found the job used to
retry for successful completion during which this msg was
given.

in View job history
it gives could not open the output file.
the interesting point is that it is occuring exactly 1 hr
10 min after the previous retry.

Pls suggest ..
anonymous NO[at]SPAM discussions.microsoft.com
2/27/2004 11:39:42 AM
Hi darren

thanks for reply

If it is the problem with the path, why its giving error
only at times not always. as specified it is schedule to
run every 1 minutes, it runs fine for nearly an hour so
then throws the error msg and job fails.
"could not open the output file."

pls suggest
Darren Green
2/27/2004 5:50:31 PM
In message <351801c3fd54$9cbae4c0$a301280a@phx.gbl>, haseeb
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

The could not open output file is due to an invalid path being specified
for the job step output files and should be easy enough to correct. I
sort this first to try and get some more error info.

I assume you are using Dts, since this is the Dts group, in which case
parameter is incorrect is a common issue around versions and service
packs.

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
Darren Green
3/1/2004 10:01:57 PM
In message <08e001c3fd69$7235aea0$a601280a@phx.gbl>,
anonymous@discussions.microsoft.com writes
[quoted text, click to view]

Is something else using the file? Is the file being written to at all?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
AddThis Social Bookmark Button