title: SQL Query for appending rows into destination using SSIS
body: <p>I have Created a SSIS Package for Importing the Records from One Table to Another table . It is Working Properly But In Source table records are increasing on regular basis . Therefore I am executing package regularly . In Package Before inserting New rows I truncate the records from Destination table then Executing Package .</p>
  
  <pre><code>        SQL TASK -1 
  
          Truncate table "OLE DB Destination"
  
          SQL TASK -1 
  
          CREATE TABLE "OLE DB Destination" (
  
             "ZZCOIL_APPR10" NVARCHAR2(20),
             "ZZSTORAGE_LOC10" NVARCHAR2(15),
             "ZZDETAIL1" NVARCHAR2(40),
             "ZZTOTAL_QTY" NUMBER(7, 2),
             "ZZNOTE1" NVARCHAR2(100),
             "ZZNOTE2" NVARCHAR2(100)
                                             )
  </code></pre>
  
  <p>But I don't Want that solution , I want to insert Only Remaining Records which are not present in Destination table . </p>