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:

  1. 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).
  2. but if not work, try changing value of 2nd key '2' '0' stands 'dontsavesensitive' , try again.

please mark post answer if helps :)


Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -