无法在 SSIS 中打开 excel 源代码 [英] Can't open excel source in SSIS

问题描述

我有一个 C# 程序，它从电子邮件下载一个 excel 文件，然后从 Excel 到 DB 插入一个 SSIS 来读取和插入刚刚下载的数据.C# 下载文件，然后 SSIS excel 源无法识别该文件，我无法预览它，出现以下错误:SSIS 错误

I have a C# program that download an excel file from Email then a SSIS insert from Excel to DB to read and insert the data that was just downloaded. The C# download the file and then the SSIS excel source doesn't recognize the file and I can't preview it, I get the following error : SSIS Error

如果我手动打开文件然后返回到 SSIS excel 源，我可以预览文件并且它工作正常，文件似乎以某种方式被锁定，任何帮助将不胜感激.

If I manually open the file then go back to SSIS excel source I can preview the file and it works fine, it seems like the file is somehow locked, any help will be appreciated.

推荐答案

我能够通过创建另一个 C# 程序来解决这个问题，该程序在下载完成后打开 excel 文件并将其添加到 SSIS 流程中，所以现在文件将被下载 -> 打开和关闭 -> 然后加载到 excel 源.

I was able to fix this by creating another C# program that opens the excel file once its done downloading and I added it to the SSIS flow, so now the file will get downloaded -> open and closed -> then loaded to the excel source.

这篇关于无法在 SSIS 中打开 excel 源代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！