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
Author
Message
Posted Thursday, January 3, 2013 5:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 10:36 AM
Points: 2,045, Visits: 1,400
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
Post #1402303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse