title: How to prevent Data Generation Plan timeout expired error
body: <p>I'm attempting to populate a DB on my local SQL2008 Server using a Data Generation Plan.  However, when I run it I get:</p>
  
  <blockquote>
    <p>Data generation failed because of the following exception: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.. occurred 1 time(s).</p>
  </blockquote>
  
  <p>I've tried setting the Connection timeout setting in the Advanced connection properties to 120 instead of 15, but I still get the error.</p>
  
  <p>How do I fix this problem?</p>
  
  <p>There are roughly 40 tables involved and about 20 of those are getting 100 rows inserted while, 10 tables ~1000 rows and the rest less than 100 rows.  Also, when I exclude the trouble table the script completes successfully.  </p>
  
  <p>Thanks!</p>