title: How do you automate data loads in visual studio?
body: <p>I am pretty new to SSIS and SQL in general, and I am still learning the ropes. I am trying to create a few integration packages. First step would be to retrieve the data from one database and load it into another. I've been using the data flow task for this ... However the next step would be to run this package once a daily at a given X time (eg. 1 am). The landing database would be continuously updated , just like the source.</p>
  
  <p>On a seperate package, I'm looking for a way to copy the data from my landing database, and dump it all into another table. This needs to be done so that the package automatically retrieves the rows from the landing database, before it gets overwritten everyday.</p>
  
  <p>Any suggestions? 
  Thanks!</p>