I have a Parent package which call different child packages.I have schaduled
the Parent package to be executed evey 3 minutes and I'm using a Table in
which I insert the name of the child package which is working and when it is
done I delete the row,by this mechanism I control not 2 child packages get
executed at the same time(Because they do transactional things on their own
table, and I won;t tend to be stuck in deadlocks).

Problem is that I am expecting that two different child packages could be
executed at the same time but for some reason when Parent package call one
child package and it takes more than 3 minutes,none of the other packages
run.There is no any other instance of Parent package running.

When I schadule something ,it is supposed to be run at an specific interval
right?

Thanks

The same job cannot be run more than once at the same time.

A way to control child package exeution would be to link them through
workflow wouldn't it?


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"J-T" <J-T (AT) nospam (DOT) com> wrote

Hi Allan,

My parent package is a separte package than the child packages.I load the
package based on the CSV file which is recieved in Parent package,then in an
Activex script I load the appropriate package.

create two or three jobs of my Parent Package,can I? My only concern is that
child packages logging the validation errors in one Table (That table is
shared between all the child packages).Will I be stuck in dead lucks or
something? I insert the log records by calling a stored procedure (no
transaction involved) in child packages(there is a Execute SQL Task in each
child package which referes to that stored procedure).

Thanks for your help Allan (as always:-))

Cheers,


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

The same package cn be called at the same time multiple times.

OK so what I think you are trying to do is this

Fire a DTS package every 3 minutes (Parent)
In the parent package you check a csv file. Based on the CSV file you call
a package(Child)

I am not sure how you do the check here.

Would it be possible for you to fire the package based on an event? The
file being dropped?


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"J-T" <J-T (AT) nospam (DOT) com> wrote

Thanks Allan,

My idea is now working.I schaduled the Parent package twice to be executed
after 3 minutes (I have two jobs of the same parent package).As I siad child
packages write their logs into a common table using a stored proc (with one
simple insert and no transaction).Apparently everything is fine.

information I decide which package I should execute.In the meantime I use a
table to keep track of executing packages and by using that table I won;t
let two instance of the same package run at the same time.Reason is that In
child packages I call stored procedures which use Transactions and I don;t
wnt to be tarpped by deallock or stuff like this ,that's why I came up with
the idea of not letting two instances of the same child package run at the
same time ,but I can have differnet instances of the child packages working
simultaniously .

Makes sense?

Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote