We have around 600 SSIS packages running in our production Server. We need to update the Connection timeout property of one of the connection managers ( We to need update connection timeout from 0 to 30 seconds). This connection manager has been used in all the packages. I am looking a way to update this property in all the packages at one-time. So far I have fetched all package's XML data
SELECT s.name, CONVERT(XML,CONVERT(VARBINARY(MAX), packagedata))
FROM [msdb].[dbo].[sysssispackages] s
Need help to update only a particular property in a specific connection manager. Any help much appreciated.