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

Need to call a batch file from a remote server Expand / Collapse
Posted Wednesday, October 10, 2012 1:08 PM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:10 AM
Points: 251, Visits: 225
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
Posted Wednesday, October 10, 2012 1:37 PM



Group: General Forum Members
Last Login: Today @ 12:21 PM
Points: 13,783, Visits: 35,414
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.:


--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
Posted Thursday, October 11, 2012 1:08 AM



Group: General Forum Members
Last Login: Today @ 10:53 AM
Points: 6,114, Visits: 14,910
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

I had some words with my wife, and she had some paragraphs with me.
Post #1371235
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse