Home Dashboard Directory Help
Search

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


Status: 

Active


5
0
Sign in
to vote
Type: Bug
ID: 772231
Opened: 11/26/2012 7:55:10 AM
Access Restriction: Public
0
Workaround(s)
view
3
User(s) can reproduce this bug

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).
Details
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.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Formulier_Budget_AWBZ_2013.xls (restricted) 11/26/2012 -
ExcelErrorCouldNotDecryptFile2012.jpg 11/26/2012 308 KB
ExcelErrorCouldNotDecryptFile.jpg 11/26/2012 121 KB