Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Weard DTS Error - help

Status
Not open for further replies.

bigfoot

Programmer
May 4, 1999
1,779
US
I wrote a small DTS to transfer a table to a text file named c:\testfile.txt

When I run it from DTS, it runs great. When I run it from ASP.net, it gives me this error:

Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Error opening datafile: Access is denied.

Step Error code: 80004005
Step Error Help File:DTSFFile.hlp
Step Error Help Context ID:0

There is no place to give permissi0ons to writing text files is there?

I checked permissions, and C on my server has everyone full control. What could it be? I ran a DTS that updated a column in a SQL database and it ran fine under the SAME user. Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top