Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Include Excel workbook password in OLEDB ACE 12.0 connection string Expand / Collapse
Posted Thursday, January 3, 2013 5:15 AM


Group: General Forum Members
Last Login: Saturday, November 7, 2015 1:49 AM
Points: 2,574, Visits: 1,651
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
Post #1402303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse