updating only certain columns from source table to destination table

• koolme_85

  Ten Centuries

  Points: 1153

  More actions

  January 5, 2011 at 1:15 pm

  #232976

  i have a package that pulls data from TABLE1

  and does dataconversion and two look ups

  and insert the data into destination table

  now based on a single column (the common column from sourcetable and destination table )

  i want to update only a few columns in destination

  for example

  if CJdate from source table = YEAR day in destination table

  then i want to update only COL1,COL2,COL3 out of COL1,COL2,COL3,COL4 ......COL10

  thanks

  regards

  greg

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  January 5, 2011 at 1:22 pm

  #1269734

  Add a conditional split in your data flow that looks at the column you want to check. Then route the rows that match the condition to an OLE DB Command task to update the rows.

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden