visual studio 2008 - SSIS 2005 dtsx Objects Migration to SQL Server 2012 -
i have heaps of dtsx objects on file system (2005 compatible), of objects have encryptsensitivewithuserkey
setup developer no password available.
i need migrate dtsx objects sql server 2012, getting error try migrate expected.
could guys suggest way change or overwrite encryptsensitivewithuserkey
of dtsx object on file system.
i not want open object in visual studio change permission level talking 400+ objects migration.
appreciate quick response.
are using external xml configuration file project?
in case, add key file:
<configuration configuredtype="property" path="\package.properties[packagepassword]" valuetype="string"><configuredvalue></configuredvalue></configuration> <configuration configuredtype="property" path="\package.properties[protectionlevel]" valuetype="int32"> configuredvalue>2</configuredvalue></configuration>
note:
- in 2nd key-value pair, value 2 stands 'encryptsensitivewithpassword'. giving empty value package password in 1st key should not cause problem (it didn't give problems me).
- but if not work, try changing value of 2nd key '2' '0' stands 'dontsavesensitive' , try again.
please mark post answer if helps :)
Comments
Post a Comment