January 6, 2009 at 9:24 pm
What is an execution tree in SSIS in BIDS 2005? And how to create it? I have a SSIS package which has a group for drop and create a database and tables for data warehouse, and another group for load data into these tables. When I run the task, one by one, through the time I created the SSIS, everything was OK. But when I run the package, both of group run in the same time, finally it showed the error :" Database is currently in use..." I think an execution tree is the best thing for me now, but i don't know how to do that. Please help me! (sorry if my english is too bad)
January 7, 2009 at 3:50 am
As you said that when you execute the package both the groups starts running in parallel, and this is what causing the error. You need to add a "precedence constaint" from the first group (drop, create Db, create talble) to the another group (table loading). Remember that in the "precedence constraint" you should select "On Success"
By doing this, these goups will not execute in parallel, these will execute in sequence. First the database will be dropped, created and once that is done your table will be populated.
-Vikas Bindra
Sr. Software engineer - BI
-Vikas Bindra
January 9, 2009 at 8:14 pm
Thank you so much, I did as your advice, and it worked 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply