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 FileHave 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-6737fcb5a0c9I 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).
Operating System Language
Steps to Reproduce