Please see if the workaround given in below blog helps - ssis-using-source-of-password-protected-excel-files
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi All,
I want to import password protected excel file into SQL Server using SSIS.
Please help me
Please see if the workaround given in below blog helps - ssis-using-source-of-password-protected-excel-files
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Hi vaishu,
Could you please share the steps that you create the excel file with password protected?
Best Regards,
Mona
If the response is helpful, please click "Accept Answer" and upvote it.
Hi vaishu,
According to my test, the Excel Source cannot read the password protected excel file.
May I know if you can open the excel file?
May I know if you can remove the password by clicking Unprotect Sheet or Protect Workbook and entering the password?
Please refer to Require a password to open or modify a workbook.
Best Regards,
Mona
If the response is helpful, please click "Accept Answer" and upvote it.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more