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 FileTSFFile.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?
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 FileTSFFile.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?