SSIS : Cannot open the datafile

[Ladouceur]

Hi,

If I run the package from BIDS, it works fine. If I run the package inside Management Studio it works when I run it as a package.

It does NOT run when I schedule the job.

Error: 2008-03-12 10:51:56.16
Code: 0xC020200E
Source: Data Flow Task Flat File Destination [194]
Description: Cannot open the datafile "D:\old_timesheet_repos\TimeSheet\files\date.txt". End Error
Error: 2008-03-12 10:51:56.16
Code: 0xC004701A
Source: Data Flow Task DTS.Pipeline
Description: component "Flat File Destination" (194) failed the pre-execute phase and returned error code 0xC020200E. End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 10:51:55 AM Finished: 10:51:56 AM Elapsed: 0.344 seconds.
The package execution failed. The step failed.,00:00:01,0,0,,,,0

Any idea?

Thanks in advance.
Eric.

 

[Ladouceur]

I was able to solve the issue by giving full control permission to the 'users' group on that file.