Post reply

Executing SSIS package without BIDS

  • April 22, 2009 at 6:39 am

    #133400

    Just wanted to know how do i execute a ssis package without BIDS.

    I have tried the following and failed:

    1) By job - Job does not give execute SSIS package option as BIDS is not installed

    2) xp_cmdshell - this does not work as i dont have execute permission on this.

    Any other way to execute the package?

  • April 22, 2009 at 8:03 am

    #982199

    Panks (4/22/2009)

    Just wanted to know how do i execute a ssis package without BIDS.

    I have tried the following and failed:

    1) By job - Job does not give execute SSIS package option as BIDS is not installed

    2) xp_cmdshell - this does not work as i dont have execute permission on this.

    Any other way to execute the package?

    Open "cmd" console and enter DTEXEC. This is the executable used to execute SSIS packages. If it runs properly, setup a SQL Job Step with CmdExec type of command and then use DTEXEC and the appropriate parameters to execute your 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