How can I define a working connection to a secured excel document within DTS.
Where and how can I provide the excel password to access the secured
document as a data source (named data ranges within the document)

Regards,

Adri

There are UserID and Password properties on the Excel connection object
which may be of help.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Adri Cleymans" <Adri Cleymans (AT) discussions (DOT) microsoft.com> wrote

Alan, thanks for your reply, however I do not find any userid or password
property when defining an excel connection.
Perhaps I also did not describe the problem correctly. It concerns an excel
(oe multiple excels) which are 'shared and secured'.
When trying to connect to such an excel, I get the message 'Error source:
Microsoft Jet database engine, Error mesage: Can not decode the file'

How can I dynamically override this security issue ?

Thanks in advance.

"Allan Mitchell" wrote:

You can access the userid and password using disconnected
edit. In the designer, go to Package, select disconnected
edit. Expand the connections node and then select the
Microsoft Excel connection. On the right, you will see the
userid and password properties.

-Sue

On Tue, 5 Apr 2005 00:55:03 -0700, "Adri Cleymans"
<AdriCleymans (AT) discussions (DOT) microsoft.com> wrote:

I tried it on my end to see what would happen, but it actually doesn't
even let me use the excel file that is password protected
"Error source : Microsoft Jet Database Engine
Error Description : Could not decrypt file"

Adri - I guess you can create an excel connection to an excel
spreadsheet that is exactly like the password protected one, create your
transformations and what not on that, then once completed, you may be
able to change the filename to to the password protected file using
disconnected edit, or dynamic properties, and add the username and
password that way.

Simon Worth

Sue Hoegemeier wrote: