Hi ,

I created a DTS package and it running fine when I run in design view.
But when I scheduled it , it fail to run and I get this kind of error ,

"Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 9/21/2005 10:45:53 AM
Step Execution Completed: 9/21/2005 10:45:53 AM
Total Step Execution Time: 0.063 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services Flat File Rowset

Provider

Step Error Description:Error opening datafile: Access is denied. "

I suspect is the security issue but I am not sure where can I debug it.
- The package was created under user "sa" - SQL Server Admin
- The package was scheduled under user "sa" - SQL Server Admin

- The DTS package will extract the data from a csv file from a "Share
Folder"
- The "Share Folder" was restricted to only certain users

Please advise.

One more issue , how to I show the "Step Name" in my error log instead of
showing the "DTSStep_DTSDataPumpTask_1" ?

Travis Tan