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

Protect the Excel files generated by SSIS package-Part I Expand / Collapse
Author
Message
Posted Wednesday, October 27, 2010 9:43 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:11 PM
Points: 55, Visits: 414
Comments posted to this topic are about the item Protect the Excel files generated by SSIS package-Part I
Post #1012032
Posted Thursday, October 28, 2010 12:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
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
Posted Thursday, October 28, 2010 2:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:41 AM
Points: 6, Visits: 103
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
Posted Thursday, October 28, 2010 2:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:11 PM
Points: 55, Visits: 414
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
Posted Thursday, October 28, 2010 3:50 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 29, 2014 4:30 AM
Points: 5,345, Visits: 1,388
Good and useful one...


Post #1012163
Posted Thursday, October 28, 2010 10:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Good information, thanks. But I'm not sure I want to install Excel on the SSIS servers...
Post #1012461
Posted Thursday, October 28, 2010 11:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:11 PM
Points: 55, Visits: 414
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
Posted Thursday, October 28, 2010 12:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:26 PM
Points: 377, Visits: 8,634
very helpful article, thanks for posting this!
Post #1012582
Posted Thursday, December 13, 2012 8:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 8:42 AM
Points: 8, Visits: 144
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 »

Add to briefcase

Permissions Expand / Collapse