Hello,

I have a package built in EM that gets columns from a
table and transfers them to an existing Excel document.
The package creates the appropriates columns in a new page
an does the transfer.
Everything works well in EM and dtsrunui.
Using the code generated by dtsrunui, I execute the query
in QA:
exec master..xp_cmdshell 'DTSRun...'

And I get:
Error string: Failure creating file.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003436

four times, all related to : Error = -2147467259
(80004005)
two of them are linked to: Provider Error: -329978796
(EC54EC54)

Since I have four columns to transfer, I thought there was
a link, but I tried transfering in an existing page, and
the error remains (occuring only once each, but still).

There has to be something wrong, but I can't see what.Any
hint appreciated.

Elno

the 80004005 error suggests either a security issue or that something you
are trying to use simply does not exist.

--


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

"El No" <pompier_4449 (AT) yahoo (DOT) fr> wrote

Thanks.
To avoid any owner/runner rights issues, I went on the
server, logged on as sa, saved the old package there, ran
it with EM and dtsrunui (using windows authentication): no
problem. As soon as I go in QA (as sa, on the server) and
run xp_cmdshell, I get the errors again.
Could it still be a "right" issue, or has it to be
something else?
Hints appreciated,

Elno

Hi,

The sa being quite busy these days, (with the sun and
all ;-)) I talked to him this morning. Totally correct
with the accounts response. Passwords have been changed
recently, but not all of them had been updated, without
problem for everything already running...
Thanks a lot!

Elno