title: MS Access query in SSIS
body: <p>I appear to be having some difficultly with MS Access 2016 and SSIS.</p>
  
  <p>I’m having to build a reporting application built over an MS Access DB. I am trying to SSIS data to create flat tables for the application to query off for performance reasons.</p>
  
  <p>I noticed today that some queries/views that produce results in Access give zero results in SSIS. I feel this could be from the nasty auto generated SQL by MS Access. But is there a way to get round this issue without re-writing the sql?</p>
  
  <p>I’m currently connecting to the access dB via jet 12.0 ole DB connector in SSIS. Any help would be hugely appreciated.</p>