Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute SSIS Package from other server Expand / Collapse
Author
Message
Posted Tuesday, August 11, 2009 2:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 22, 2010 7:45 AM
Points: 3, Visits: 39
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?
Post #768424
Posted Tuesday, August 11, 2009 9:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:44 PM
Points: 1,114, Visits: 2,196
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/

Post #768713
Posted Wednesday, August 12, 2009 4:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 22, 2010 7:45 AM
Points: 3, Visits: 39
User, who runs the dtexec command must not to by local admin on the sqlserver. And then it faild.
Post #769191
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse