Protect the Excel files generated by SSIS package-Part I

  • blessonblessons

    SSC Eights!

    Points: 929

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

  • Raunak Jhawar

    SSCoach

    Points: 15701

    Nice article John.

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

    Please follow here

    Regards/Raunak
    Now a member of Linkedin

    Please visit the all new Performance Point Forum
    Please visit the all new Data Mining and Business Analytics Forum

  • frederico_fonseca

    SSChampion

    Points: 14174

    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: 929

    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.

  • Anipaul

    SSC-Insane

    Points: 24681

    Good and useful one...

  • UMG Developer

    SSChampion

    Points: 13482

    Good information, thanks. But I'm not sure I want to install Excel on the SSIS servers...

  • blessonblessons

    SSC Eights!

    Points: 929

    I am sorry,basically you need PIAs to run the code.After a bit of search I found that you can download the PIAs

    http://msdn.microsoft.com/en-us/library/aa159923(office.11).aspx

    and then reference them in C# code.HTH.

    Thank you all for your comments.I will soon post another method to protect Files.

  • Mark Eytcheson

    Ten Centuries

    Points: 1202

    very helpful article, thanks for posting this!

  • sachiek-915178

    SSC Rookie

    Points: 30

    I am getting this error. Not Able to resolve this soo far. It could be security issue or whatever.

    Author - mind to share some idea?

    Error - The process exit code was "-1073741819"

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

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