Need to call a batch file from a remote server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Need to call a batch file from a remote...

Need to call a batch file from a remote server

Rate Topic

Display Mode

Topic Options

Author

Message

SQL08Kid

Posted Wednesday, October 10, 2012 1:08 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 29, 2013 4:15 PM
Points: 208, Visits: 196

Hey guys,

I'm creating a SSIS package and one of the first steps is to stop services on a remote server so I created a batch file on the remote server (NET STOP blah blah...) but now I need a way of calling this file. Any help?

Post #1371087

Lowell

Posted Wednesday, October 10, 2012 1:37 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 11,627, Visits: 27,693

it's been a while since i sued it but PSEXEC from the PSTools suite is designed for executing things on a remote system...there might be some permissions issues if you are trying to use it via tSQL, but that's one possibility.:
http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1371096

Phil Parkin

Posted Thursday, October 11, 2012 1:08 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:42 AM
Points: 4,239, Visits: 9,482

Yes, this is harder than you might think. PSEXEC is what I have used in the past.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1371235

« Prev Topic | Next Topic »

Permissions