SQLServerCentral / Integration Services / Data Warehousing / Include Excel workbook password in OLEDB ACE 12.0 connection string / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 04:21:39 GMT20Include Excel workbook password in OLEDB ACE 12.0 connection stringhttp://www.sqlservercentral.com/Forums/Topic1402303-364-1.aspxIs 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 regardsLempsterThu, 03 Jan 2013 05:15:37 GMTLempster