Post reply

Initiate package from MS Access

  • June 25, 2009 at 6:26 am

    #135455

    I have a process (SSIS) that I would like a user to be able to initiate on demand, primarily from MS Access. Is there an equivalent to a stored procedure the user can submit, but the execution be an SSIS package?

    Thanks in advance.

  • June 25, 2009 at 7:49 am

    #1015312

    Howard C. BAchtel (6/25/2009)

    I have a process (SSIS) that I would like a user to be able to initiate on demand, primarily from MS Access. Is there an equivalent to a stored procedure the user can submit, but the execution be an SSIS package?

    Thanks in advance.

    The SSIS packages are executed using DTEXEC executable. If you are able to initiate process from Access, then you will be able to run the package.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply