Hi,

I have a SQL Package with a owner password and a execute password(is
this so-called?). This means that a user can execute a package but not
look into it.

I want to read the package in visual basic.net but i recieve an error
on these packages: "Access to package properties requires entry of
package owner password". But when i look at the parameters of the
LoadFromSQLServer i cant give in a owner password only an execute
password. This is in contrast with SaveToSQLServer method which has a
parameter for an owner password(???)

So could someone give my some light in the darkness?

Hennie

In message <191115aa.0501131245.501dcaf5 (AT) posting (DOT) google.com>, Hennie de
Nooijer <hdenooijer (AT) hotmail (DOT) com> writes
I agree it is a bit confusing only having one package related password
for LoadFromSqlServer, but you can actually supply either the owner or
operator (execute) password. Either should work to load the package, but
if you try and read properties or variables then you require the owner
password, so you must supply that in the method.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

well i did use the owner and the execute password but this doesn't help.
I still getting this error? When i open the package in SQL server i can
enter the password and this accepted by SQL server but not in visual
basic.net?




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi I had it wrong. It's working now. thanx

Hennie


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!