Running Powershell as SQL Server Agent task

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  January 28, 2016 at 4:00 am

  #324276

  Hi,

  with Powershell in Agent-Task:

  i want to check if a File in Folder exists, then goto next Step - else goto Failure.

  Is Powershell the best way to check this - or cmdExec - or SSIS ????

  (SQL2012, PSV3)

  Regards

  Nicole

  😉

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 28, 2016 at 8:11 am

  #1854963

  SSIS seems to me overkill for just checking a file exists.

  Powershell can do that:

  $ErrorActionPreference = "Stop"

  if( -not (Test-Path "c:\temp\im_not_there.txt")) { throw "Not there!" }

  CMD can do that as well

  if not exist c:\temp\im_not_there.txt exit /b 1

  -- Gianluca Sartori