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