title: How to UPDATE all columns in a Table from FLAT FILE Source
body: <p>My DB Table does not Update columns from an OLE DB Destination, I need to UPDATE all columns in an OLE DB Destination table that I get from a FLAT FILE Source (.csv). </p>
  
  <p>The .csv file data inside changes everyday, so when i execute the DATA FLOW, the FLAT FILE Source updates fine, but the data in the OLE DB Destination does not update, so the DB Table never updates data.</p>
  
  <p>Should I configure an OLE DB Command ?</p>
  
  <p>So this is what I have and how I have set it up. </p>
  
  <ol>
  <li><p>I'm using SQL Server 2012 STD</p></li>
  <li><p>I have a SSIS Project in Visual Studio.</p></li>
  <li><p>DATA FLOW has been set up.</p></li>
  <li><p>Inside DATA FLOW I have FLAT FILE Source that connects to an OLE DB Destination. (works fine)</p></li>
  <li><p>All connection managers setup and working fine.</p></li>
  <li><p>Tables has been created in Management Studio already.</p></li>
  </ol>
  
  <p>If i need to use an OLE DB Command, should it be something like this:</p>
  
  <pre><code>UPDATE table
  SET column1=?, column2=?, column3=?
  WHERE column1=?, column2=?, column3=?
  </code></pre>
  
  <p>Here is my actual query i need to use, will this work ?</p>
  
  <pre><code>
  set 
  candidateName=?, 
  candidateFirstname=?,
  candidateLogin=?,
  candidateEmail=?, 
  candidateRefNumber=?, 
  candidateGuid=?,
  candidateEntityName=?, 
  'M-Sure Client Engagement Specialist'=?,
  'Area Sales Manager'=?, 
  Region=?, 
  'Group Name'=?, 
  'FSB License Holder'=?,
  'Agent Name'=?, 
  trainingId=?,
  trainingTitle=?,
  trainingGuid=?, 
  sessionId=?,
  sessionTitle=?,
  sessionGuid=?,
  sessionStartDate=?, 
  sessionEndDate=?,
  contentGuid=?, 
  contentRefNumber=?,
  contentTitle=?,
  firstLaunchDate=?,
  completionTime=?, 
  score=?, 
  timeGlobal=?, 
  progression=?, 
  status=?
  
  WHERE
  
  candidateName=?, 
  candidateFirstname=?,
  candidateLogin=?,
  candidateEmail=?, 
  candidateRefNumber=?, 
  candidateGuid=?,
  candidateEntityName=?, 
  'M-Sure Client Engagement Specialist'=?,
  'Area Sales Manager'=?, 
  Region=?, 
  'Group Name'=?, 
  'FSB License Holder'=?,
  'Agent Name'=?, 
  trainingId=?,
  trainingTitle=?,
  trainingGuid=?, 
  sessionId=?,
  sessionTitle=?,
  sessionGuid=?,
  sessionStartDate=?, 
  sessionEndDate=?,
  contentGuid=?, 
  contentRefNumber=?,
  contentTitle=?,
  firstLaunchDate=?,
  completionTime=?, 
  score=?, 
  timeGlobal=?, 
  progression=?, 
  status=?```
  </code></pre>