<Configuration CnfiguredType="Property" Path="\Package.Properties[PackagePassword]" ValueType="String"><ConfiguredValue></ConfiguredValue>
</Configuration>
</DTSConfiguration>
I've a package using a xml configuration file. And i want to set the package password in the string above. But the thing is, it doesn't work. Here's what it looks like after i've putted the password.
<Configuration CnfiguredType="Property" Path="\Package.Properties[PackagePassword]" ValueType="String"><ConfiguredValue>value</ConfiguredValue>
</Configuration>
</DTSConfiguration>
But when i try to run it. It complains. So i've to set the password at the comand line using decrypt. Anybody got a similar problem? I really want to don't have to set the password in the command line.
Thanks,
Adriano Coura
I think, and someone else may correct me on this, that the package can't be opened in order to begin reading the configurations until a password is supplied.|||
jwelch wrote:
I think, and someone else may correct me on this, that the package can't be opened in order to begin reading the configurations until a password is supplied.
True.|||Then why there's the option to set the package password in the config file? Because it looks good? Can somebody explain to me that? I really would like to know.
Thanks|||
abcoura wrote:
Then why there's the option to set the package password in the config file? Because it looks good? Can somebody explain to me that? I really would like to know. Thanks
It looks like that list of properties simply contains the list of public methods that are writable.
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.package_members.aspx
No comments:
Post a Comment