May 9, 2012 at 2:28 pm
Hi there -- I've searched the forums and books and still cannot find out what I need to know to get my project working correctly.
So here's the situation: I have a C# app I've written that dynamically builds a *.dtsx package.
a. the package contains X number of sequence containers
b. each Sequence Container has the SQL calls and DFTs necessary to move a set of data from one table on a production server to a reporting server
I had it all running perfectly when I was using VS2008 to programatically build the DTSX files. However, I moved it to VS2010, and now I have a problem.
In the example I'm working with, I have 68 Sequence Containers. When the package gets run, it runs the first step of each 68 containers, and when that's done, it runs the second step for each 68, and so on.
What I want it to do, and what it did before, was to run each Sequence Container from start to finish.
Using the "MaxConcurrentExecutables" property, I could control how many individual Sequence Containers were running at one time (this is what I want!).
Logically, I want it to be processing the DFTs for 3 or so tables at at time. As soon as it completes work for one Sequence Container, it moves on to the next.
I've done all sorts of diffs and I cannot for the life of me figure what would have made the package execution change.
For the record, I don't have any precedence constraints between the individual Sequence Containers (nor do I think that I want any -- I don't care in which order they get executed).
Can anybody offer any pointers on what I should be looking at? Thanks for any help! 🙂
May 9, 2012 at 2:58 pm
To see what is being generated I would probably save the package out and then open it in bids and see what it is generating and see if it differs from what you think its doing..
CEWII
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply