SSIS Commit problem

• fremus7

  SSC Journeyman

  Points: 92

  More actions

  September 9, 2010 at 6:55 am

  #157191

  Hi all,

  I encountered the following problem:

  I have a package that has the following:

  - on pre execute: "Execute SQL task" - this will update a particular status table (oracle)

  - Package will read data from the source - clean the data - and store the data to a destination (sql server)

  - on post execute - "Execute SQL task" - this will update a particular status table (oracle)

  my problem is that the "execute sql task" doesnt seem to commit itself.

  A very dirty workaround is that I manually do a "commit" of the table and re-run the process.

  Is there a way were i can "commit" the SQL Task after it is executed?

  Thanks in advance

• fremus7

  SSC Journeyman

  Points: 92

  More actions

  September 9, 2010 at 7:05 am

  #1218565

  Hi again,

  I just noticed that its an oracle issue, where auto commit is not done when doing a manual update or so.

  This being said, the SQL task is successfully updating oracle with no problems.

  Sorry for the inconvience

  Thanks