ssis - "Flat File Source" (471) failed the pre-execute phase and returned error code 0xC020200E. How do I stop this Happening? -
hi wonder if can help...
every single week error.
"flat file source" (471) failed pre-execute phase , returned error code 0xc020200e. cannot open datafile "g:\data\to processed\ro_orders.csv".
i know if go flat file connection manager editor , browse file @ location "g:\data\to processed\ro_orders.csv" work. if have reset location of file every week yet, file in same location has been.
i have not edited file, or moved location.
i have lots of other packages load different types of data , fine.
also have logging file attached errors.
i not believe ownership error can run other packages , owned same person.
this reoccuring annoyance cant seem work out why happening...ideas?
thanks in advance.
try setting connection string in expressions
. enter full file path on server of file loading under connectionstring
property.
Comments
Post a Comment