ETL Operation-spanning transactions
14 views
Skip to first unread message
Louis Haußknecht
Oct 19, 2009, 4:54:22 AM10/19/09
to Rhino Tools Dev
Hello,
before I insert rows in my last operation, I want to truncate the
target table.
Is it possible to have one transaction span multiple operations?
before I insert rows in my last operation, I want to truncate the
target table.
Is it possible to have one transaction span multiple operations?
Ayende Rahien
Oct 19, 2009, 4:57:03 AM10/19/09
to rhino-t...@googlegroups.com
Truncate isn't a transactional operation.
Louis Haußknecht
Oct 19, 2009, 5:24:33 AM10/19/09
to Rhino Tools Dev
Okay, that's true ;),
but apart this, is it possible to span the transaction?
but apart this, is it possible to span the transaction?
Ayende Rahien
Oct 19, 2009, 7:10:49 AM10/19/09
to rhino-t...@googlegroups.com
Yes, you would need to setup it up so both operations share the same transaction, though.
It would probably require extending the current operations.
It would probably require extending the current operations.
Reply all
Reply to author
Forward
0 new messages