December 15, 2009 at 7:43 am
I have a task in an SSIS package that reads rows from an access table and inserts them into a table in a SQL Server 2005 database. Ive implemented checkpoints, but cant figure out how i would rollback the inserts if the task failed. The import source table uses an OLE DB source thats pointed to the access table and the destination uses an OLE DB connection thats pointed to SQL Server. So if this task fails and im implementing checkpoints, i can re-run the package and it will start from the beginning of the failed task. But before the task failed, several thousand (or millions) of rows may have already been inserted. I dont want to insert them again, so some sort of rollback would be needed. If it was standard SQL I could just use BEGIN TRANSACTION and ROLLBACK if it failed, but this is a direct access to sql transfer. How can I implement this using the 2 OLE DB sources ? Is it possible to modify code manually ?
December 17, 2009 at 1:51 pm
Try putting the tasks in a sequence container.
Sequence containers are meant to handle transactions
------------------
Why not ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply