title: ODBC: Which server to configure it on?
body: <p>I'm needing to create/configure an ODBC connection, but I'm a little fuzzy on the where. My goal is for an SSIS package to extract the data from an Access file and populate a SQL table on a recurring (daily) basis.</p>
  
  <p>Here's my scenario:</p>
  
  <p>Server 1 contains a program that populates and maintains an MS Access DB file. This file is the raw data source I need for populating a SQL table via SSIS.</p>
  
  <p>Server 2 is the server that houses my SQL installation. </p>
  
  <p>Which server do I need to configure ODBC on? Based on the MS documentation, I'm not sure if it should be where the Access file is, or if it should be where the SQL/SSIS lives.</p>