Best way to call a DTS package from Stored Proc

• aaa121

  SSCertifiable

  Points: 5902

  More actions

  September 21, 2007 at 2:26 am

  #69182

  Hi All,

  I have tried to use the DTS Run utility but have experiencing hanging and latency issues. I need to run the DTS package pretty much instantly upon execution of the stored proc.

  Any ideas?

  Thanks

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  September 21, 2007 at 8:34 am

  #735263

  Adam,

  DTSRun is pretty much what you're stuck with as far as I'm aware... I'd be inclined to investigate why the package was hanging. Things like:

  1. What task is the package execution when it starts to hang?

  2. Are there any msgbox or inputbox statements (possibly left over from debugging)?

  3. Does the package execute any Execute Process tasks (the likes of PSExec can hang if the user confirmations aren't stored in the repository)?

  If you can provide some information about the hanging task, we should be able to help further.

  Ade

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]