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.
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).