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

Status : 

 


5
0
Sign in
to vote
ID 772231 Comments
Status Active Workarounds
Type Bug Repros 3
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 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.