title: SSIS import file versus retrieving data directly from source
body: <p>We wish to import data into a SQL Server database from a source location located elsewhere in the company WAN in another country. </p>
  
  <p>We are to be using SSIS to perform the import but wonder where would be the best place to perform the extract and transform. We could create a view on the source SQL server and SSIS will directly retrieve data from that. The alternative would be to drop a file out of the source and have SSIS import the data from that file.</p>
  
  <p>I am thinking the former is a cleaner solution but would be interested to know whether there are any benefits in using files or potential issues with grabbing the data direct?</p>
  
  <p>Thanks</p>