Home Forums SQL Server 2012 SQL 2012 - General SSIS Package Run from xp_cmdshell reports success before package is run RE: SSIS Package Run from xp_cmdshell reports success before package is run

  • December 16, 2013 at 9:03 am

    #1673743

    It doesn't really matter WHERE the package is located. Running it via xp_cmdshell is the ENTIRE problem. Once the command shell has been invoked, SSIS is done with it. However, it may be worth doing a search to see if there might be an option or property on the execution of that statement to wait for completion, but even that might not do any good.

    Wayne.Emminizer (12/16/2013)

    Thanks for your reply. What I don't totally understand though is when the package was running in MSDB, it wouldn't end until the package ends. Is the problem now that it's running through the package store?

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)