Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -53,3 +53,24 @@
53	53	UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
54	54	WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
55	55	{{/code}}
	56	+
	57	+=== System Settings ===
	58	+
	59	+{{code language="SQL"}}
	60	+
	61	+UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
	62	+WHERE txtDocumentDatabaseConnection NOT LIKE '%Encrypt%'
	63	+
	64	+UPDATE prgSystemSettings SET txtDocumentDatabaseConnection = REPLACE(REPLACE(txtAdditionalDocumentDatabaseConnection, ';pwd=', ';Encrypt=true;pwd='), ';Password=', ';Encrypt=true;Password=')
	65	+WHERE txtAdditionalDocumentDatabaseConnection NOT LIKE '%Encrypt%'
	66	+{{/code}}
	67	+
	68	+=== SSIS Service Steps ===
	69	+
	70	+{{code language="SQL"}}
	71	+UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtFromConnectionString, ';Password=', ';Encrypt=true;Password=')
	72	+WHERE txtFromConnectionString NOT LIKE '%Encrypt%'
	73	+
	74	+UPDATE tblSSISServiceSteps SET txtFromConnectionString = REPLACE(txtToConnectionString, ';Password=', ';Encrypt=true;Password=')
	75	+WHERE txtToConnectionString NOT LIKE '%Encrypt%'
	76	+{{/code}}