DTS and Excel thru ASP

DTS and Excel thru ASP

Post by R3JlZ0lwYX » Sun, 29 Aug 2004 02:07:02


I have an DTS package that copies an excel spread sheet into a sql server
table. The exel document is located in the web server and is referenced in
the package as such. It runs fine thru Enterprise mananger, however on the
web it fails on the
excel copy procedure. The web server does not have Excel installed on it,
does it need to have ?? Does it need to open the Excel spreadsheet, or is it
looking for some kind of ODBC connection ??? I am totally lost and fairly new
to this, Code is quite simple,
so it's got to be a permission thing ??? or Excel will need to be loaded on
the web server ?? If anyone can help that would be great. Also when coming
in thru the web, is it using the userid I assigned or an nt authinacation one
??? What userid is the web using