Post reply

How to call SSIS package deployed in different machine

  • May 28, 2009 at 4:57 am

    #221669

    I need to call an SSIS package from stored procedure using dtexec utility. My SSIS package is deployed in a different machine than my database server. My package is deployed using File system method. When I give Ip address along with the path of the package, it is not getting triggered. Kindly help.

  • May 28, 2009 at 8:49 am

    #1001472

    ramchaitanya_4 (5/28/2009)

    I need to call an SSIS package from stored procedure using dtexec utility. My SSIS package is deployed in a different machine than my database server. My package is deployed using File system method. When I give Ip address along with the path of the package, it is not getting triggered. Kindly help.

    Do you get an error reported? You have to give permissions to the network share where the package resides.

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

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

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