• 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/