October 27, 2010 at 9:43 pm
Comments posted to this topic are about the item Protect the Excel files generated by SSIS package-Part I
October 28, 2010 at 12:22 am
Nice article John.
We also have a thread running on password protecting an Excel file.
Please follow here
Now a member of Linkedin
Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
October 28, 2010 at 2:20 am
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?
October 28, 2010 at 2:50 am
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.
October 28, 2010 at 3:50 am
Good and useful one...
October 28, 2010 at 10:04 am
Good information, thanks. But I'm not sure I want to install Excel on the SSIS servers...
October 28, 2010 at 11:07 am
I am sorry,basically you need PIAs to run the code.After a bit of search I found that you can download the PIAs
and then reference them in C# code.HTH.
Thank you all for your comments.I will soon post another method to protect Files.
October 28, 2010 at 12:45 pm
very helpful article, thanks for posting this!
December 13, 2012 at 8:22 am
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