“平面文件源"(471) 预执行阶段失败并返回错误代码 0xC020200E.我如何阻止这种情况发生? [英] "Flat File Source" (471) failed the pre-execute phase and returned error code 0xC020200E. How do I stop this Happening?

问题描述

我想知道你是否可以帮忙...

Hi I wonder if you can help...

我每周都会收到此错误.

Every single week I get this error.

平面文件源"(471) 在预执行阶段失败并返回错误代码 0xC020200E.无法打开数据文件G:\Data\To be processing\RO_Orders.csv".

"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".

我知道，如果我进入平面文件连接管理器编辑器并在此位置浏览文件G:\Data\To be processing\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?

提前致谢.

推荐答案

尝试在 Expressions 中设置连接字符串.在 ConnectionString 属性下输入您正在加载的文件的服务器上的完整文件路径.

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

这篇关于“平面文件源"(471) 预执行阶段失败并返回错误代码 0xC020200E.我如何阻止这种情况发生?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！