August 11, 2009 at 2:11 am
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?
August 11, 2009 at 9:21 am
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."
August 12, 2009 at 4:26 am
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