SSIS - OLEdb destination Get Success/Failure status and update SQL

• bharathi.kannan

  Old Hand

  Points: 318

  More actions

  February 19, 2015 at 9:15 am

  #314695

  Hi,

  I have a SSIS pkg that gets data from SQL and do data conversion and Insert into OLE db AS400 destination, There is a flag column in SQL table , that has to be updated to true, once the records are inserted in AS400 how do i do that in SSIS

  SQL oledb ---------> dataConversion ---------------> AS400 OLE db Destination

  |

  update SQL table Flag column<-----------|

  Any help appreciated.. thank you

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  February 19, 2015 at 9:51 am

  #1778689

  Please do not crosspost. It wastes peoples time and fragments replies.

  Original thread with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1661770-2799-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP