Home Forums SQL Server 2008 T-SQL (SS2K8) SSIS Package Inside Trigger keeps running endlessly RE: SSIS Package Inside Trigger keeps running endlessly

  • October 18, 2012 at 6:57 am

    #1550440

    Eugene Elutin (10/18/2012)

    Did your "above you" insisted that you should use trigger to execute XP_CMDSHELL? Or they just told you that SSIS should start as soon as records inserted?

    I would not definitely, under any circumstances, call xp_cmdsheel from a trigger - just NEVER.

    You may try to create scheduled task and use msdb.dbo.sp_start_job to start it from the trigger, that may be a bit better...

    Also you can use Service Broker.

    Hi Eugene,

    The "above me" above me asked me to call the SSIS package from a Trigger without making the package a part of a job. So I was pretty much left with Xp_cmdshell. Any other suggestions of doing it are very welcome. Thanks for ur time.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉