Re: Providing password for SQL Login in SSIS package

#1

One of many options is to set the ProtectionLevel to "encrypt sensitive
with password".

However i do not see why package configurations doesn't work for you.

/NIklas

vnapoli skrev:

Quote:

I have a package that is to run as a scheduled process from the SSIS Service
under a different account than the one that created it, using a SQL login to
Oracle as defined in the connection manager. I am encountering the
protectionLevel restriction in SSIS and not sure how to get past it. How
does one provide the password for a sql (in this case Oracle) login to the
package? I have tried package configurations.

#2

Configurations should work. I usually set the Protection Level property
of the package to Don't Save Sensitive and pass in Sensitive info from a
configuration.

--

Regards

Allan Mitchell

Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"niklas.arbin (AT) nordicstation (DOT) com" <niklas.arbin (AT) nordicstation (DOT) com> wrote
in message news:1166607312.112636.192110 (AT) 79g2000cws (DOT) googlegroups.com:

Quote:

One of many options is to set the ProtectionLevel to "encrypt sensitive
with password".

However i do not see why package configurations doesn't work for you.

/NIklas

vnapoli skrev:

I have a package that is to run as a scheduled process from the SSIS
Service
under a different account than the one that created it, using a SQL
login to
Oracle as defined in the connection manager. I am encountering the
protectionLevel restriction in SSIS and not sure how to get past it.
How
does one provide the password for a sql (in this case Oracle) login to
the
package? I have tried package configurations.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Providing password for SQL Login in SSIS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Providing password for SQL Login in SSIS package - 12-20-2006 , 03:35 AM

Re: Providing password for SQL Login in SSIS package - 12-22-2006 , 04:52 AM