Summary

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

Details

Page properties

Content

...	...	@@ -53,24 +53,3 @@
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}}