SSIS update the destination database -

i need update value in sharepoint list if 1 list item values submitted using ssis

sharepoint list columns 1) status 2) text

the destination , source sharepoint list same. if value in list item submitted need update text column have sql query update value

update       dbo.sharepoint set                text = { fn concat(text, '1') }        (formstatus = 'submitted') 

1) added sharepoint list source , sharepoint destination 2) have created connection manager using spcred. 3) add update query . can change caml query in component queries items 'submitted' . how update list.

is there better way using ssis

this solution applicable only if sharepoint list source , destination 2 different tables.

1. start source connection - submitted values , go 3, or go step 2 if getting rows.
2. put conditional split condition: (dt_str,50,1250)[formstatus] == "submitted"

3. add derived column component, <replace ...> property. drag existing column value expression field , add text want.

   (dt_str,50,1250)[formstatus]+"1"

4. finish destination connection , proper column mapping

otherwise (1 sharepoint table want modify) please use sql task in control flow, update wrote.