Execute SSIS Package from other server

  • I want to run SSIS package from another server from command prompt:

    dtexec /DTS "\MSDB\Package_transfer" /SERVER sqlserver /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V

    I got following answer:

    Microsoft (R) SQL Server Execute Package Utility

    Version 9.00.3042.00 for 64-bit

    Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 2:45:13 PM

    Could not load package "\MSDB\Package_transfer" because of error 0xC00160AA.

    Description: Connect to SSIS Service on machine "sqlserver" failed:

    Access is denied.

    .

    Source:

    Started: 2:45:13 PM

    Finished: 2:45:13 PM

    Elapsed: 0.313 seconds

    Have anybody idea, where is the problem?

  • danodan (8/11/2009)


    I want to run SSIS package from another server from command prompt:

    dtexec /DTS "\MSDB\Package_transfer" /SERVER sqlserver /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V

    I got following answer:

    Microsoft (R) SQL Server Execute Package Utility

    Version 9.00.3042.00 for 64-bit

    Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 2:45:13 PM

    Could not load package "\MSDB\Package_transfer" because of error 0xC00160AA.

    Description: Connect to SSIS Service on machine "sqlserver" failed:

    Access is denied.

    .

    Source:

    Started: 2:45:13 PM

    Finished: 2:45:13 PM

    Elapsed: 0.313 seconds

    Have anybody idea, where is the problem?

    You have permissions problem. It says "Access is denied."

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

  • User, who runs the dtexec command must not to by local admin on the sqlserver. And then it faild.

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

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