Integration Services Roll back on Failure
Posted on 2007-07-26
I am new to integration services (sql server 2005) and am trying to set up a DTS package (SSIS Package).
In old sql, I would make a package. As part of the package I would make it a transaction and roll back on failure.
I have a oracle database and a SQL database. I want to import from oracle.table1 into sql.table1, replacing the rows in sql.table1 with those from oracle. Using the wizard, it provides a turncate statement followed by a dataflow of import.
However, I need it to roll back to pre-turncate if the import fails. What step am i missing?