> I would like to create a DTS package that will import a password
> protected
> excel file into SQL. But I get get an unable to decrypt the file
> error when
> I try to link it to either a file dsn, or system connection. Does
> anybody
> have any ideas on how this can be accomplished.
> It should be simple but I am not finding any way to accomplish this.

>>Thread-Topic: import password protected file into SQL
>>thread-index: AcaaxBcxkYUaF96+RA6sXHiJVw2yXg==
>>X-WBNR-Posting-Host: 216.241.38.19
>>From: =?Utf-8?B?U2NodW1s?= <larrys@news.postalias>
>>References: <CBE6D154-548B-4FCD-9C03-F606A95529AF@microsoft.com>
<xoPklQnmGHA.5184@TK2MSFTNGXA01.phx.gbl>
>>Subject: RE: import password protected file into SQL
>>Date: Wed, 28 Jun 2006 08:04:02 -0700
>>Lines: 6
>>Message-ID: <986012A6-1FFF-4E26-8891-2EEE4CCA39F8@microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.dts
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:66696
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.dts
>>
>>Thank You for the information, I beleive you are right, I havent found
>>anyway to succesfully import the data other than the methods mention in
the
>>articles you provided. The articles you provided are helpful and we will
>>utilize the workarounds that are in article :
>>http://support.microsoft.com/?id=211378
>>
>>