We use SSIS to grab all the information from MAS for use in reporting. We use the ODBC driver to do this.

This works with no issues the majority of the time. Occasionally, but still often enough, there will be an issue with the extraction, causing the job to fail.

The job will then continue to fail until the MAS server gets restarted, then there are no issue.  

My question is if there is a way to determine which pvxwin32.exe process is doing what? My hunch is that the one for the extraction gets hung up... thus why the refresh fails until MAS gets restarted.