I set up a dts package on one of our sql servers to pull the data from
one table and export it to an excel spreadsheet located on a networked
server. When I execute the package from within enterprise manager, it
works fine. However, when I use an .asp page to try to execute it, I
get an error saying it cannot find the file specified. It occurs on
this line....

oPkg.LoadFromSQLServer
"server","user","password",DTSSQLStgFlag_Default," ","","","packagename"

.... it doesn't even get down to the oPkg.Execute() line. I know that
the server that the asp page is running on can see and access the sql
server, so I am positive that's not the problem. And since I can run
the package within enterprise manager successfully, doesn't that mean
that sql server can see the server where the excel spreadsheet is
located? The sql server is version 7 and we installed version 7 dlls
and tools on the server running the asp page, so they're both running
the same version of sql. Anyone have any ideas? Thanks.

Are you running into version problems?

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"geoff" <cakewalkr7 (AT) hotmail (DOT) com> wrote