I have a table(servername,flag) with a list of servers.
I would like to ping the servers and check for connectivity.
Can I create a boolean expression using xp_cmdshell in SSIS ,if it is a success flag the servername record with 1 else with 0.
how can I do this without scripting in SSIS.
Thanks