Wednesday, March 7, 2012

Problem with xml configuration

<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