title: Periodically run query to transfer data between two SQL Servers
body: <p>I have two MS SQL Servers, let's call them <strong>Source</strong> and <strong>Destination</strong>. I need to bring some data from a database table in <strong>Source</strong> by making a simple query (a <strong>Select</strong> and a <strong>Sum</strong>) and bring the result to a database table in <strong>Destination</strong>.</p>
  
  <p>I need to run the query <strong>once a month</strong> in order to have available the data in <strong>Destination</strong> to be used by an application.</p>
  
  <p>I was thinking about doing it at <strong>application layer</strong> by creating a workflow (which is complex and not worth for such a simple issue) but I would like to know whether there is a easier option by using <strong>SSIS</strong> or any other tool. It is especially unclear to me how to set up the <strong>trigger</strong> to run the query and <strong>where to place</strong> the query code.</p>