Aysnchronously calling a package

Hello,

Is there a way to call SSIS package within another SSIS package, asynchronously. Any pointers would be much appreciated.

Thanks

Vishal

Say if you control flow looks like:

step 1
|
|
|_
| |
| |
step 2 step 3
|
|
step 4
And say step 3 is execute package task that you want to run asynchronously.
Can you describe your issues with this? Are you looking for event handlers?

Nitesh

|||

[Including Michael's answer for posterity]

You can use Execute Process task to run the package using DTEXEC.EXE utility.

To run DTEXEC without execute process task waiting for it, either specify a small timeout and set TerminateProcessAfterTimeOut to false, or start the DTEXEC using ‘cmd /c start dtexec.exe /F filename’ command.

AWE Enabled + Security Settings set but still no memory increase?

Hi,
If anyone has come across a similar issue, any help would
be appreciated . We have a WIN2k3 Server (not advanced)
running SQL 2k Enterprise. We have installed an
additional 2gb worth of memory ramping it up to 4gb. We
have set up AWE enabled settings on SQL 2k and adjusted
the local security settings. Problem is that we never
get above 2gb on our memory usage? Can someone explain
why this is happening and maybe highlight something that
I have missed? The reason for installing the additional
memory was to reduce dts loads and sql qry times that hit
2gb memory capacity on a daily basis?!?! Why doesnt sql
use the additional 2gb?!!
Thanks in advance
PaulI presume you have increased the maximum amount of memory SQL Server can use
(Enterprise manages, right click server, properties, memory)? Does it
recognise there is now 4gb in the machine?
"Paul" <ptel4d@.hotmail.com> wrote in message
news:073701c351bd$5eee7320$a601280a@.phx.gbl...
> Hi,
> If anyone has come across a similar issue, any help would
> be appreciated . We have a WIN2k3 Server (not advanced)
> running SQL 2k Enterprise. We have installed an
> additional 2gb worth of memory ramping it up to 4gb. We
> have set up AWE enabled settings on SQL 2k and adjusted
> the local security settings. Problem is that we never
> get above 2gb on our memory usage? Can someone explain
> why this is happening and maybe highlight something that
> I have missed? The reason for installing the additional
> memory was to reduce dts loads and sql qry times that hit
> 2gb memory capacity on a daily basis?!?! Why doesnt sql
> use the additional 2gb?!!
> Thanks in advance
> Paul