title: SSIS missing data from SQL table using Fast Load
body: <p>I have a bit of a problem. When I set up a SSIS package and i fire it off it shows me the amount of rows that is going into the SQL table, but when I query the table there is almost 40000 rows missing from what the last count was after the conditional split that I have in the package.</p>
  
  <p><img src="https://i.stack.imgur.com/UqSCe.png" alt="SSIS package"> </p>
  
  <p><img src="https://i.stack.imgur.com/YQNO2.png" alt="enter image description here"></p>
  
  <p>What causes this problem? Even if I have it on normal table or view it still does the same thing. But here I have to use the <strong>fastload</strong> option as it is a lot of source files being loaded. This is only testing before sending it to production and I am stuck at the moment. Is there a way I can work around this problem and get all the data that is supposed to be pumped into the table. please also take note that in the conditional split it removes any NULL values as seen in first picture. </p>