Can't read Excel file with cell protection in SSIS - by SSISJoost

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


6
0
Sign in
to vote
ID 772231 Comments
Status Closed Workarounds
Type Bug Repros 4
Opened 11/26/2012 7:55:10 AM
Access Restriction Public

Description

I have an Excel file with cell protection that I want to use a source in SSIS. Unfortunately SSIS gives me an error when I'm using it as an source: Could Not Decrypt File

Have also posted a question in the SSIS forum, but I believe this is a bug.
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e4752e16-6ec4-4366-957a-6737fcb5a0c9

I have used 32bit, tried imex=1 and tested it in SSIS 2005, 2008 and 2012. It works when I remove the cell protection or when I keep the file open in Excel (not a workaround on a server).
Sign in to post a comment.
Posted by Microsoft on 6/1/2016 at 7:38 PM
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.
Posted by Ralf Dietrich - datafino GmbH on 11/27/2013 at 3:09 AM
Even xls might be outdated we have sometime to load a buch of old excel files - they won't go away :)
There is no way to open tousend of xls-files for removing password protection from worksheets

Please have an eye on this!
Posted by SSISJoost on 12/3/2012 at 6:20 AM
SSIS doesn't have the same problem with XLSX files... only XLS.