Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mc2
Starting Member
1 Post |
 Posted - 2005-10-17 : 11:22:06
|
| Hi,We upload a number of files from various sources and would like to return a load analysis, i.e. good, bad, total data. A lot of this information is of a sensitive nature, so I would also like to password protect the output, which preferably needs to be in XL format.Can anyone offer some guidance on this?Thanks. |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-17 : 12:06:09
|
| Hi,I don't know how close I am but you can do this from front end using VB 6.0, VB.NET or C#. Generate the XL document using Excel API. Then protect it with password or zip it.Other wise generate a private key for the file and encrypt it and make a tool to read the file using de-crypt key. Just an idea.RegardsSachin |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-10-18 : 01:53:05
|
| You can use excel object in an activex task inside the dts package, may not be a good idea thoughThanksKarunakaran |
|
|
|
|
|
|
Export to XL and Password protect