title: Why doesn't SSIS OLE DB Command transformation insert all the records into a table?
body: <p>I have an SSIS package that takes data from Tables in an SQL database and insert (or update existing rows) in a table that is another database.</p>
  
  <p>Here is my problem, after the <code>lookup</code>, I either insert or update the rows but over half of the rows that goes into the insert are not added to the table.</p>
  
  <p>For the insert, I am using an Ole Db Command object in which I use an insert command that I have tested. I found out why the package was running without error notification but still not inserting all the rows in the Table.</p>
  
  <p>I have checked in sqlProfiler and it says the command was <strong>RCP:Completed</strong> which I assume means it supposedly worked. </p>
  
  <p>If I do the insert manually in sql management studio with the data the <strong>sql profiler</strong> gives me (the values it uses toe execute the insert statement with), it works. I have checked the data and everything seems fine (no illegal data in the rows that are not inserted).</p>
  
  <p>I am totally lost as to how to fix this, anyone has an idea?</p>