Include Excel workbook password in OLEDB ACE 12.0 connection string

  • Is it possible to denote in an OLEDB ACE 12.0 connection string that an Excel workbook is password-protected and also to include the password? Part of the Extended Properties attribute maybe?

    I have written an SSIS package to export data from SQL Server 2005 to an Excel workbook and now I've been asked whether it is possible to include the option to password protect the workbook when it is generated and populated by the package.

    Thanks and regards

    Lempster

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply