How To Update data?

How To Update data?

• Devin G

  Aaahhh - it was prophetic therefore that I used s in my message. Many thanks!
  
  

• Melinda_MSFT

  Ash Sharma has an excellent post on the subject here: http://sqljunkies.com/WebLog/ashvinis/archive/2005/03/10/8732.aspx

  -Jamie

  
  
  

• orourksj

  You put s in the sql statement and then use the Column mapping to map each column in the flow to the relevant parameter, (one for each parameter)
  
  

• farang

  Hi Simon,
  
  I had thought of that but could not think how do it ... in the Update statement how do I access the row columns that I am updating from
  
  ie update tablename set colname = where id =    (how do I fill in the s )
  
  
  
  What is the SCD
  
  Thanks
  Mark
  
  

• Yassir Zoheiri

  Just a question - using the Oledb command to update each row is quite slow - is there no faster / better way to update data

  Thanks,

  Nicole

  
  

• tony42472

  Thanks!
  

• Bob2unlimited

  Use the OLE DB Command component with an update statement.
  
  You could use the SCD that would enable inserts to be done as well if rows aren't found.
  
  
• How To Update data?