Summary

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

Details

Page properties

Content

...	...	@@ -31,46 +31,3 @@
31	31	[[image:1623328456852-301.png]]
32	32	1. Click the **Generate STP File**  and save the STP file again
33	33	[[image:1623328525432-818.png]]
34		-
35		-== Database Settings ==
36		-
37		-
38		-=== Parent Service ===
39		-
40		-{{code language="SQL"}}
41		-UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
42		-WHERE txtConnStr NOT LIKE '%Encrypt%'
43		-
44		-UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
45		-WHERE txtDocConnStr NOT LIKE '%Encrypt%'
46		-
47		-UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
48		-WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
49		-
50		-UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
51		-WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
52		-
53		-UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
54		-WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
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}}