Hi Sudeep, Yes, my user has is Administrator. Thanks,

Hi All, I keep getting the following error, when running the my SSIS Package thru SQL Agent. But when I execute my package thru BIDS, I don't received any error like this. Code: 0xC020205B Source: Load New Members Create RAW files [667] Description: File "D:\Rewards\ETL\Rawfiles\newmembers" cannot be opened for writing. Error may occur when there are no file privileges or the disk is full. End Error Error: 2011-11-23 20:59:21.98 Code: 0xC004701A Source: Load New Members SSIS.Pipeline Description: component "Create RAW files" (667) failed the pre-execute phase and returned error code 0xC020205B. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:59:20 PM Finished: 8:59:22 PM Elapsed: 1.109 seconds. The package execution failed. The step failed. Anyone can help, please. Thanks,

check if the user under which the job is running has access to this folder: D:\Rewards\ETL\Rawfiles\newmembersMy Blog | Ask Me

Is it the SQL Server admin or the System admin? Also ensure that the job is run under your user id. Check if you can access the folder mentioned and it has the required space.My Blog | Ask Me

Hi Sudeep, Yes, my user has is Administrator. Thanks,

Is it the SQL Server admin or the System admin? Also ensure that the job is run under your user id. Check if you can access the folder mentioned and it has the required space.My Blog | Ask Me

Hi Sudeep, Thank you for mentioning about the access to the folder. Apparently, the folder that the raw file is located is in the network drive. So I put on a read and write access to the folder and then the Job run successfully. Thanks a lot,