Execute SSIS Package from other server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Execute SSIS Package from other server

Author

Topic

danodan
Starting Member

1 Post

Posted - 2009-08-10 : 09:50:30

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?

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-12 : 13:07:49

The error says "Access is denied."

Permission the user (or agent account) on the other server.
Or, in the dtexec call, include the User and Password of a valid user on the other server: dtexec /U ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources