> Hi Garrett
>
> I have just built a package with the exact same details as your post
> and I do not get the error. The error suggests it cannot get a
> aconnection to your XL File. This however would be true regardless of
> whether or not you used Configurations.
>
> --
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
> "garrett.fitzsimons@gmail.com" <garrett.fitzsimons@gmail.com> wrote in
> message news:1173184708.658114.102370@s48g2000cws.googlegroups.com:
>
>> I have a SSIS package that loads the contents of a worksheet in an
>> Excel document into a table.
>> Simple process;
>> 1) Extract from Excel using Excel Connection Manager 2) Insert into
>> SQL2005 Database Table using OLEDB Connection Manager.
>>
>> I am using ExcryptSensitiveWithPassword and have set a password on
>> the package.
>>
>> The Package works fine until I enable Package-Configuration for the
>> Connection Managers.
>>
>> If I check the checkbox for Excel-Connection-Manager and save the
>> package-configuration-file then I get an error message;
>>
>> Error: The AcquireConnection method call to the connection manager
>> "Excel Connnection Manager" failed with error code 0xC0202009"
>>
>> I can reproduce this at will by switching the checkbox on/off and
>> saving the configuration file.
>>
>> This is all done on a standalone Notebook running SQL2005.
>>
>> Can anyone explain the levels of security/configuration at play here
>> ?
>>
>> It would seem that there is a complex relationship between the
>> 'Protection Level' and the 'Package Configuration' - one I cannot
>> find a sufficient explanation for.
>>
>> Can anyone add to this ?
>>
>> My goal is to have a package that can be easily ported from server to
>> server, and will allow an admin person to modify the path to the
>> excel file.
>>
>> Many Thanks.
>>

"Simon Sabin" wrote:

> Hello Garrett
>
> Has the setting in the configuration file been set correctly?
>
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>
> > Hi Garrett
> >
> > I have just built a package with the exact same details as your post
> > and I do not get the error. The error suggests it cannot get a
> > aconnection to your XL File. This however would be true regardless of
> > whether or not you used Configurations.
> >
> > --
> >
> > Allan Mitchell
> > http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> > http://www.konesans.com
> > "garrett.fitzsimons@gmail.com" <garrett.fitzsimons@gmail.com> wrote in
> > message news:1173184708.658114.102370@s48g2000cws.googlegroups.com:
> >
> >> I have a SSIS package that loads the contents of a worksheet in an
> >> Excel document into a table.
> >> Simple process;
> >> 1) Extract from Excel using Excel Connection Manager 2) Insert into
> >> SQL2005 Database Table using OLEDB Connection Manager.
> >>
> >> I am using ExcryptSensitiveWithPassword and have set a password on
> >> the package.
> >>
> >> The Package works fine until I enable Package-Configuration for the
> >> Connection Managers.
> >>
> >> If I check the checkbox for Excel-Connection-Manager and save the
> >> package-configuration-file then I get an error message;
> >>
> >> Error: The AcquireConnection method call to the connection manager
> >> "Excel Connnection Manager" failed with error code 0xC0202009"
> >>
> >> I can reproduce this at will by switching the checkbox on/off and
> >> saving the configuration file.
> >>
> >> This is all done on a standalone Notebook running SQL2005.
> >>
> >> Can anyone explain the levels of security/configuration at play here
> >> ?
> >>
> >> It would seem that there is a complex relationship between the
> >> 'Protection Level' and the 'Package Configuration' - one I cannot
> >> find a sufficient explanation for.
> >>
> >> Can anyone add to this ?
> >>
> >> My goal is to have a package that can be easily ported from server to
> >> server, and will allow an admin person to modify the path to the
> >> excel file.
> >>
> >> Many Thanks.
> >>
>
>