"Flat File Source" (471) failed the pre-execute phase and returned error code 0xC020200E. How do I stop this Happening?

Question

Hi I wonder if you can help...

Every single week I get this error.

"Flat File Source" (471) failed the pre-execute phase and returned error code 0xC020200E. Cannot open the datafile "G:\Data\To be processed\RO_Orders.csv".

I know that if i go into the flat file connection manager editor and browse for the file at this location "G:\Data\To be processed\RO_Orders.csv" it will work. It is as if i have to reset where the location of the file is every week yet, the file is in the same location as it always has been.

I have not edited the file, or moved the location.

I have lots of other packages which load different types of data and they are fine.

Also I have a logging file attached for errors.

I also do not believe it is a ownership error as I can run the other packages perfectly and they are all owned by the same person.

This is a reoccuring annoyance that I cant seem to work out why it is happening...Ideas?

Thanks in advance.

Answer 1

Try setting up the connection string in Expressions. Enter full file path on the server of the file you are loading under ConnectionString property.

Answer 2

For me, this was a permissions error when running the package as a job through SQL Server.

The Solution was to add the User account that runs SQL Server to the folder with read/write permissions.