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."