Running a bat file

• infodemers

  SSCommitted

  Points: 1513

  More actions

  August 23, 2012 at 12:13 pm

  #260988

  Hi,

  From a VB script task in SSIS, I am trying to run a bat file.

  Here is my piece of code. This works fine from Visual Studio but when running it under a scheduled SQL job, it hangs.

  Any idea? Is there a security warning on server I do not see?

  'Run the batch file created previously, to download the raw data files.

  Dim myProcess As New Process

  With myProcess

  .StartInfo.UseShellExecute = True

  .StartInfo.Arguments = " /c \\BLMCIK\CMAMS\Monthly\getMonthlyAllFiles.bat"

  .StartInfo.FileName = "cmd.exe"

  .StartInfo.WindowStyle = ProcessWindowStyle.Hidden

  .Start()

  End With

  Thanks!

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  August 23, 2012 at 1:08 pm

  #1529432

  My first guess would be a permisisons issue. Does the account the SQL Agent job is running under have needed permissions to access that batch file?

  Just a thought,

  Rob

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  August 24, 2012 at 6:43 pm

  #1530011

  Execute Process Task

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato