Protect the Excel files generated by SSIS package-Part I

Question

Post reply

Protect the Excel files generated by SSIS package-Part I

blessonblessons

SSC Eights!

Points: 959
More actions
October 27, 2010 at 9:43 pm

#225575

Comments posted to this topic are about the item Protect the Excel files generated by SSIS package-Part I

Viewing 9 posts - 1 through 8 (of 8 total)

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

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

Nice article John.

We also have a thread running on password protecting an Excel file.

Please follow here

Raunak J

frederico_fonseca SSCoach Points: 16154 More actions · Answer 2

nice post.

I have just one question which may help others also.

Does the fact that you are referencing the Excel object on SSIS require a Excel install on the server?

blessonblessons SSC Eights! Points: 959 More actions · Answer 3

To run the C# code you will have to reference the object libraries "Microsoft Excel 5.0" and "Microsoft Office 11.0" and hence you have to install Excel on the server.