工作簿保护导致“外部表不是预期的格式”在SSIS [英] Workbook protection causing "External table is not in the expected format" in SSIS

问题描述

当excel工作簿没有密码保护时，进程顺利进行。但是当我的密码保护此工作簿时，我开始收到错误外部表不是预期的格式。任何可以在SSIS中完成的解决方案，以使SSIS能够读取。

解决方案

全能的互联网搜索引擎建议不能完成：
http://msdn.microsoft.com/en-us/图书馆/ ms139836.aspx

注意

您无法连接到一个受密码保护的Excel文件。

然而，您可以用另一种语言创建一个小工具（建议使用powershell），这将能够使用密码（您必须提供此工具）打开擅长的密码，并保存工作簿的版本，无需使用SSIS的密码。

或者：不要密码保护您用于SSIS的优点。为了保护您可以考虑为所有用户设置有限/限制/无访问的位置，但将运行SSIS的位置。

I have an SSIS package that is supposed to load files from excel into SQL Server.

Process goes smoothly when excel workbook is not password protected. But when I password protects this workbook, I starts getting error External table is not in the expected format. Any solution that can be done within SSIS to enable SSIS to read this.

解决方案

The almighty internet search engines suggest it cannot be done: http://msdn.microsoft.com/en-us/library/ms139836.aspx

Note

You cannot connect to a password-protected Excel file.

However you could create a little tool in another language (powershell is suggested) that will be able to open the excels for you with the passwords (that you have to provide this tool) and save a version of the workbook without password for your SSIS to use.

Alternatively: Dont password protect the excels you use for your SSIS. For protection you might consider setting up a location with limited/restricted/no access for all users but the one that will run the SSIS.

这篇关于工作簿保护导致“外部表不是预期的格式”在SSIS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！