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

Popular posts from this blog

html5 - What is breaking my page when printing? -

c# - must be a non-abstract type with a public parameterless constructor in redis -

ajax - PHP/JSON Login script (Twitter style) not setting sessions -