Share via

How to import password protected Excel file into sqlserver using ssis

vaishu 1 Reputation point
2020-08-19T07:36:18.593+00:00

Hi All,

I want to import password protected excel file into SQL Server using SSIS.
Please help me

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,641 Reputation points
    2020-08-19T07:47:41.563+00:00

    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

    0 comments
  2. Monalv-MSFT 5,896 Reputation points
    2020-08-19T08:16:02.87+00:00

    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.

  3. Monalv-MSFT 5,896 Reputation points
    2020-08-20T06:24:15.473+00:00

    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.

  4. Deleted

    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