title: Extracting "Initial Catalog" From a Connection String in SSIS 2008
body: <p>Hi Can anyone help me with a Regular expression to extract the value of Initial Catalog from a Connection String ?</p>
  
  <pre><code>  'Data Source=server\instance;Initial Catalog=MyDatabase;Integrated Security=True'
  </code></pre>
  
  <p>I want to extract 'MyDatabase' from the connection string</p>
  
  <pre><code>   Catalog=(?s)(.*); 
  </code></pre>
  
  <p>Using above mentioned Expression. I want only the Database name. How can i make it ignore Catalog and ; at the end and any possible blank spaces</p>