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