title: Can you monitor the execution of an SSIS package, in BIDS, as it runs on the server?
body: <p>Although my title states my current goal, I am open to alternative solutions.  In short, I have a series of SSIS packages that are scheduled to run on a nightly basis, on our SQL Server machine.</p>
  
  <p>Due to various updates that happen in the <em>ether</em> of my corporate-IT, some times these exports brake and the process will stop working, in the middle of the job.  To troubleshoot this process, I fire up BIDS on my workstation and restart which ever process fails.  This is useful because it's been my experience that any error generated from within BIDS are much more useful than anything I've found from within SQL Server/Package Execution History or the servers event logs.</p>
  
  <p>Historically, my problem has been that not all problems will occur in BIDS, but they will, consistently on the server.  These issue have been painful to diagnose and have cost me a lot of time.</p>
  
  <p>As such, what I would like to do is publish my package to the SSIS server, start the server instance from BIDS and monitor the project as it runs.  Is this possible?</p>
  
  <p>If not, is there something else that I can do so that I can monitor the internal steps as the process executes?</p>
  
  <p>I fear that none of this may be possible but I have to ask.  It will make my debugging and troubleshooting life so much easier.</p>