SSIS 大容量插入任务怎么循环本地路径下的文件？

Question

弄了一个 FOR EACH 循环本地文件，将结果再赋给 大容量插入 组件的sourceconnection。总是报错，报错如：

[大容量插入任务] 错误: 指定的连接“c:\resaultx10300.txt”无效，或者所指的对象无效。若要继续，请指定一个有效的连接。

Answer 1

服务器上有没有c:\resaultx10300.txt？

Answer 2

Sql service account has permission to read that file?

Answer 3

这个目录在 SSIS 包运行的服务器上需要存在

Answer 4

老大，目录是存在的，文件也是存在的。

Answer 5

Did you run ssis package on sql server? Is file on sql server's local disk? Sql service account has permission to read it?

Answer 6

Did you run ssis package on sql server? Is file on sql server's local disk? Sql service account has permission to read it?

TXT文件、包和库是在同一台，只是说 数据库不是默认的实例名。帐户的话，用的是 SA。操作系统的帐户是 ADMIN

Answer 7

Can you load data from that file with bulk insert in ssms or bcp in dos prompt?