Best way to update the status back to source in SSIS 2008

• sunilk.net

  SSC Veteran

  Points: 271

  More actions

  February 16, 2012 at 11:38 pm

  #149075

  Hello,

  I am developing an SSIS package in SQL Server 2008. The package reads the data from source, performed some transformations and updates the destination Oracle server. My package is working fine till this point. Now I want to update the transformation status back in source table for each record successfully transferred. FYI I am using OLE DB source and destination.

  Thanks,

  Sunil.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  February 16, 2012 at 11:49 pm

  #1448288

  Could you give some sample data and desired output?

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