SSIS - 无法在受保护的视图中打开 Excel 文件 [英] SSIS - Can't open Excel file in protected view

问题描述

我在尝试通过 SSIS (2012) 将 excel 电子表格加载到我的数据库时遇到了一个奇怪的问题.

I'm running into a strange issue when trying to load excel spreadsheets into my database through SSIS (2012).

我通过电子邮件获取电子表格(xlsx 文件)，然后手动将它们保存到本地驱动器 (C:\temp).当我尝试在 SSIS 中使用 excel 文件作为源时，我无法在书中选择任何 excel 表.

I'm getting the spreadsheets (which are xlsx files) via email, and then I manually save them to my local drive (C:\temp). When I try to use the excel file as a source in SSIS, I am not able to pick any excel sheets in the book.

文件没有损坏，没有在我的机器上打开，也没有密码保护.但是，它在受保护的视图中打开.所以我进入 Excel 并关闭所有受保护的视图选项，但没有雪茄.我能够将该文件用作 SSIS 中的 excel 源的唯一方法是打开它并保存它.

The file is not corrupted, not open on my machine, and not password protected. It is, however, opening in Protected View. So I go into Excel and turned off all the Protected View options, but no cigar. The only way I am able to use the file as an excel source in SSIS is by opening it, and saving over it.

有没有人有类似的经历?除了手动打开和保存所有文件，还有更好的解决方案吗?

Does anyone have a similar experience? Other than opening and saving all of the files manually, is there a better solution?

推荐答案

这是基于 xml 的 excel (xlsx) 的一个已知问题.如果您可以将它们另存为 xls，就可以解决问题.如果由于某种原因不可能，您可能需要使用 OLE 源来读取它们.

It's a known issue with xml based excel (xlsx). If you can save them as xls, that will solve the problem. If for some reason that's not possible you may need to use OLE source to read them.

这篇关于SSIS - 无法在受保护的视图中打开 Excel 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！