title: ssis want to update a sql table based on a flat file
body: <p>Rather new to SSIS so not sure how to handle this.</p>
  
  <p>I have a flat file which i managed to successfully read from. So right now my data flow consists of just a flat file source.</p>
  
  <p>What i want to do is something like this:</p>
  
  <p>Update SqlTable S
  set s.columnA = f.columna
  from FlatFile f
  where s.columnID = f.columnID</p>
  
  <p>Right now the only way i can see of doing this would be to insert the contents of the flat file into a sql table, then doing my update. This seems wasteful considering i don't need to save the data of the flat file. I just need to update an existing sql table based on the data in the flat file. So is there some way to run the query directly in the SSIS package instead of having to insert a bunch of data into a sql table that i will just wind up dropping?</p>
  
  <p>thanks</p>