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