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 11:13 am

    #1673816

    Wayne.Emminizer (12/16/2013)

    It used to work though when I was running the packages in 2008R2 with MSDB instead of 2012 and the Package Store.

    These initial packages are updating lookup tables. I have other packages that will need to run these packages if the lookup values don't exist in the database. The continuation of the package (as well as the path it takes) is dependent on the results of the subpackage.

    I just may not be understanding correctly I still don't understand why you would need xp_cmdshell to do this. Are you running this in a query window manually and would like to know when one package is complete before executing another? Or is this a scheduled process?

    If the latter, then you could use the SSIS step type in SQL Agent or master packages to make sure some packages complete before other start.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]