You are here: xp_cmdshell/DTEXEC in SSIS « MsSQL Server « IT news, forums, messages
xp_cmdshell/DTEXEC in SSIS

Posted by Hennie7863 on 07/28/06 14:48

Hi,

I'm not quit sure what the problem is but hereby a description about
the symptoms i've seen:

Situation
I have a stored procedure Start_DTSX which executes DTEXEC in a
xp_cmdshell. When i execute a dtsx package with this it wil work ok.
But when i execute a package also with a Start_DTSX stored procedure it
will not execute. The step is green but nothing has happened.

Example

Package A:
START_DTSX anpackage.dtsx

Package B
START_DTSX Package_A.dtsx

Could it be something like child/parent processes? any help
appreciated..

gr
Hennie

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация