Protect the Excel files generated by SSIS package-Part I

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Blesson John » Protect the Excel files generated by SSIS...

Protect the Excel files generated by SSIS package-Part I

Rate Topic

Display Mode

Topic Options

Author

Message

blessonblessons

Posted Wednesday, October 27, 2010 9:43 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55, Visits: 391

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

Post #1012032

Raunak Jhawar

Posted Thursday, October 28, 2010 12:22 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739

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

Post #1012093

frederico_fonseca

Posted Thursday, October 28, 2010 2:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:41 PM
Points: 2, Visits: 76

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?

Post #1012126

blessonblessons

Posted Thursday, October 28, 2010 2:50 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55, Visits: 391

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.

Post #1012137

Anipaul

Posted Thursday, October 28, 2010 3:50 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 1:35 AM
Points: 4,789, Visits: 1,336

Good and useful one...

Post #1012163

UMG Developer

Posted Thursday, October 28, 2010 10:04 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

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

Post #1012461

blessonblessons

Posted Thursday, October 28, 2010 11:07 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:46 AM
Points: 55, Visits: 391

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.

Post #1012515

Mark Eytcheson

Posted Thursday, October 28, 2010 12:45 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, January 19, 2012 3:33 PM
Points: 377, Visits: 8,621

very helpful article, thanks for posting this!

Post #1012582

sachiek-915178

Posted Thursday, December 13, 2012 8:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 2:02 PM
Points: 8, Visits: 134

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"

Post #1396221

« Prev Topic | Next Topic »

Permissions