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 2:20 am
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?
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
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.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy