title: Run a C# Application periodically to update database
body: <p>I would like to know whether it is possible to run a C# console or ASP.NET application periodically.</p>
  
  <p>My purpose is to <strong>automatically</strong> do the following steps once a <strong>month</strong>:</p>
  
  <p>1) <strong>Query</strong> a <strong>Source</strong> database.</p>
  
  <p>2) <strong>Take</strong> the result of the query at (1) and <strong>manipulate</strong> them by using <strong>LINQ</strong> and <strong>C#</strong>, for instance by checking if a certain value is already present in the Destination database.</p>
  
  <p>3) <strong>Store</strong> the derived data in a Destination database.</p>
  
  <p>The application has to run on a <strong>Windows Server 2008</strong>, the <strong>Source</strong> database is in a <strong>SQL 2005 Server</strong> and the <strong>Destination</strong> database is in a <strong>SQL 2008 Server</strong>.</p>
  
  <p>I tried to create for instance a <strong>SSIS</strong> package but it won't do the job since I cannot add any logic. </p>
  
  <p>Anybody has any suggestion?</p>