title: How to keep updating the data with SSIS?
body: <p>I am working on a Reporting Database for the decision-makers in my company so that I got the accesses from 3 different SQL database and 1 SAP server.
  I built 4 SSIS to map the raw data from those databases and loaded them into the reporting one to build Power BI mostly.</p>
  <p>However, I don't know which way is a good practice to keep the reporting database updating. For example, when a new record is created in the SQL server of the Sales Department, I want it will come to the reporting as well.</p>
  <p>I only saw SSIS could do the ETL one time, and the data I got is just until the moment I finished the first execution. If I do one more time, it will be duplicated all records loaded before with some new records.</p>
  <p>Please give me a hint from your perspective, thank so much.</p>