Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


DTS export to excel

Posted on 2011-10-24
Medium Priority
Last Modified: 2012-05-12
I vae an DTS package (SQL 200)) which exports data to a excel file. It;s all fine when I run it from QL server, but when ran from webpage there is no data exported.
Any iddeas!?
Question by:gradu
LVL 26

Expert Comment

ID: 37020479
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?

Author Comment

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

Author Comment

ID: 37020679
correction. it doesnt work for any db.

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

LVL 40

Expert Comment

ID: 37020881
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."

LVL 75

Expert Comment

by:Anthony Perkins
ID: 37021575
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.

Author Comment

ID: 37025432
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.
LVL 40

Accepted Solution

lcohan earned 2000 total points
ID: 37025655
"When from from a aspx page it creates the excel file and the workbook inside the excell file, but there is no data." - as mentioned already several times this is most likely because the user running the aspx page most likely has no access to query the table(s) in SQL server.

Author Closing Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question