looping through server list to ping without script tasks

• mtz676

  SSCrazy Eights

  Points: 9174

  More actions

  May 6, 2015 at 5:05 am

  #398414

  I am using execute SQL task to capture all server list from a column from a SQL table(serverslist,flag) and then for each server I am pinging the server using ping.exe in a SSIS process task within a for each loop container.It seems to be running fine.But how do I capture the failed and successfully pinged servers either as separate text files or dump successful pings into one table/column and unsuccessful ones into a different table/column

  or flag the successfull ones as 1 and unsuccessful ones as 0 in the same table as the servers lists

  under a different column called flag.

  Thanks

• michal.lisinski

  SSCertifiable

  Points: 6933

  More actions

  May 6, 2015 at 9:24 am

  #1795980

  Hi

  Please take a look for that example http://sqlmag.com/sql-server-integration-services/ssis-package-pings-servers, it doesn't require Task Script control to check servers.

  Thanks

  Mike