execute .bat on different server

• Alen Cappelletti

  Ten Centuries

  Points: 1172

  More actions

  October 8, 2007 at 4:35 am

  #121854

  Hi,

  I'm try to execute a .BAT file (this is on different server where integration services are on) from a SISS in execution on my server "A".

  I tryu many times but always seem the execute called from server "A" are performed on "A" and not where it is "server B".

  I mapped a disk from share but always failure result.

  Some one have experience for this kind of problem or ssis run win32 process only on the same machine of inytegration services.

  The .bat start a process (call a ftp program) that download file from SFTP server...sftp are not support in SSIS.

  Thank Alen Italy

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  October 8, 2007 at 7:46 am

  #739997

  Hi Alen - I've used PsExec to work around this issue in the past (http://www.microsoft.com/technet/sysinternals/utilities/psexec.mspx).

  Tommy

  Follow @sqlscribe

• Alen Cappelletti

  Ten Centuries

  Points: 1172

  More actions

  October 8, 2007 at 7:55 am

  #740009

  Ho tommy,

  i've found this sw and I try but always have problems....

  psexec \\manny-slave "E:\Eseguibili\PayPal_getTransaction.bat" -u manny-slave\Administrator -p myPass

  Is correct this syntax...the bat is a path to a .VBS file for start an SFTP program batch.

  Thanks Alen