How to call package with in package ?

Question

Hi All,

Actually, i have 5 different SSIS Packages. Now, third party tool will be inserting a record in mysql database for the packages to be run. Now, i need to schedule a package to run every 5mins to check whether any record get insert into the table with some status = "Open" and based on the that i need to trigger pack1, or pack2 or pack3.

Since, i am working for many technolgy i am not much familiar with SSIS. If some one help me giving tips or tools or code will be helpful

Gubs

Answer 1

You could use several SQL Agent jobs to handle this.  Have each one run every five minutes, running your specific package.  You can have a preceding job step check to see if the correct conditions exist before you attempt to launch the package, OR you can have the package check those conditions itself.

---

Answer 2

As mentioned above by the moderator, You can use SQL Agent job to handle to kick the package to run every 5 mins. Inside your package itself  -you can create a master package to call all child packages (all 3 packages that you've metioned) using execute package task from the toolbox. In the pipeline, you can double click
your constraint or expression and apply rules if necessary.


hth,

Rok

Answer 3

hello Todd,


What part of my answer didn't meet your expectation? I would appreciate if you can clarify?


thanks,



Rok

Answer 4

No offense intended - but since you asked, there are some unwritten guidelines we like to see used.  Just about every response to a post can be considered a "possible answer" - and the person who posted the response is very likely to think that their response is the correct answer, just as you did.  You'll note that my response was quite similar and I could just have easily proposed it as the answer, but I didn't.  (In fact, as a moderator, I could have marked it as an Answer outright.)  If every responder marked their own post as a potential answer, then the value of that mark is eliminated - it begins to mean nothing.

We would rather that you leave your own posts as-is.  The fact that you replied with a recommendation to the poster implies that you think this will solve their problem.  Proposing your own reply as an answer is redundant.

But please feel free to mark other replies as possible answers - but do so sparingly.  Only mark posts that you believe contain the complete answers.  If there are posts in a thread that are helpful, but don't propose a complete answer (in your opinion) then you can vote them as helpful.  Marking another poster's response as a possible answer indicates to the original poster that (at least) two people think this will solve his/her problem.  That's where I see the real value in the "Propose as Answer" mark.

Yes - in some cases this will leave a thread with multiple good possible answers with none of them marked as "proposed answers".  In my view - no harm done there - every response is almost inherently an attempt to answer the OP's query.

Again - no offense intended.  Thanks for frequenting the forum and offering advice - everyone here appreciates it.  Come back often!

---

Answer 5

Thanks for sharing the unwritten guidelines.


Rok

Answer 6

Yeah - sorry about that.  Even if we wrote it down, nobody'd read it ;)  The whole thing is a point of debate with moderators... I think we've asked the forum dev team to see how hard it would be to disable the "propose" for your own posts.  But enough with the off-topicness!

---