DTS export to excel

does the dts runtime package "dtexec" installed on your web server.
do the account under you call the package have the enough privilages t execute succesfully?

When I Connect to pubs db on the same server, it works.

correction. it doesnt work for any db.

For "(SQL 200))" which IO assume is SQL 2000 as you have DTS not DTSX you need DTSRUN as DTEXEC wasn't there at the time and also you need the DTS package on the SQL Box from where the web page is calling it. You should look for access rights to that server.folder.package for the user that hits the web page.

"The dtsrun utility executes a package created using Data Transformation Services (DTS). The DTS package can be stored in the Microsoft® SQL Server™ msdb database, a COM-structured storage file, or SQL Server Meta Data Services."

http://msdn.microsoft.com/en-us/library/aa224467(v=sql.80).aspx

It sounds like the SQL Server account does not have access to all the resources it needs.  In other words the startup account for SQL Server more than likely cannot create the Excel spreadsheet.

Unfortunately, you have not provided sufficient information, so the best we can do is hazard a guess.

I have the db on one server, the weserver on a different server and the excel file will be created on a different server.

When ran from SQL server, everything works well. When from from a aspx page it creates the excel file and the workbook inside the excell file, but there is no data.

Thanks. I had to change the scurity so webserver has access to sql server.