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!

DTS Cannot open data file from ASP

Status
Not open for further replies.

skitty123

Technical User
May 4, 2004
56
US
I have a simple DTS package which executes fine in the SQL server enterprise manager environment but
when I call it from an ASP page it fails with the error:
----------------
Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider

Step Error Description:Error opening datafile: Logon failure: unknown user name or bad password.
Step Error code: 80004005
Step Error Help File:DTSFFile.hlp
Step Error Help Context ID:0
----------------
though the text file in question does not have any restrictions and is open for read/write etc.
what is going on?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top