August 30, 2013 at 9:22 am
Hi
Hope you doing well and thanks in advance for trying to help. I am working on a requirement for which I did create 2 packages. Calling child package from parent package and each has their own database connections (to same database)
Both packages have transaction level to "supported" and in parent package am starting the transaction using "begin tran" in exec sql task.
Problem is when I am inserting a row in parent table in parent package and trying to select that row in child package (begin tran in parent package isnt committed yet..it will be committed at end in parent package).
My child package database session is getting blocked by parent package db session, I think child package creating its own db connection instead of using parent package connection.
my requirement is either to commit everything or rollback everything.
can you please help how to get the package done without getting my db sessions blocking each other?
Thanks in advance.
Sri
August 30, 2013 at 12:23 pm
I think I will answer my question ..I solved it using transaction option in SSIS package.
I learned that 2 ssis packages though they are parent and child cant share single database connection so that answers my question of leaving a open transaction in parent package could block child package when it tries to modify tables updated by parent package.
Actually found a very good alternative thats is checkpoints.
I think thats what I needed.
Thanks anyway
Sri
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply