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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 export to password protected Excel file

Author  Topic 

scabral7
Yak Posting Veteran

57 Posts

Posted - 2009-11-03 : 11:46:17
Hi,

Is there a way to export data from DTS to an Excel file that is password protected? THe key here is that i don't know the password. When i try to write to the file, i get the "could not decrypt file" error.

The reason is that this file is for our Internal Audit group and they want to be the only people who have the password.

Is there a way to get the data into this file without knowing the password? MAybe through activex or something?

thanks
Scott
   

- Advertisement -