Home Forums SQL Server 2005 SQL Server 2005 Integration Services Execute a SSIS Package with xp_cmdshell RE: Execute a SSIS Package with xp_cmdshell

  • October 24, 2015 at 7:32 pm

    #1835379

    jorge_gomes98 (10/24/2015)

    hello,

    can you tell me yf this works when you put this code into ASP page and run from remote location?

    This is exactly what i need to run a SSIS job from and ASP page...aSSIS job that creates tables from and external excel file...

    thank you.

    The Double Quotes are necessary because there are spaces in the path to the EXE.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)