title: SSIS Package connect to Readonly Database with Availability Group
body: <p>I am trying to connect to a secondary server in an availability group to use the readonly version of the database with an OLE DB connection in an SSIS package and can't seem to do it.  That simple.  Can it be done and if so how?</p>
  
  <p>Edited:
  Forgot to add that we want to be able to use a project parameter to pass in the connection string.</p>