• I do not condone using xp_cmdshell at all, and especially not for something like this, but if you must here is someone who has detailed the technique from beginning to end:

    http://www.sqlmag.com/content1/topic/ssis-package-pings-servers-143994/catpath/sql-server

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