Every 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".
If I go into the flat file connection manager editor and browse for the file at "G:\Data\To be processed\RO_Orders.csv" it will work again. It is as if I have to remind it of the file's location every week, yet it is in the same location as it always has been.
I have not edited the file nor moved it. I have other packages which load different types of data and they are fine. I have a logging file attached for errors. I also do not believe it is an ownership issue as I can run the other packages and they are all owned by the same person.
Why does this keep happening?
Try setting up the connection string in Expressions. Enter full file path on the server of the file you are loading under ConnectionString property.