In order to follow the steps as indicated, you will need to create a Business Intelligence project that has two packages. When the first package fails, you will use the OnError event to execute the other package. Simultaneously, when the first package finishes executing you verify that you can successfully ping your default gateway.
The following steps will be described in setting up a BI project with two packages:
Create a BI project and rename the default package.
Add and configure the package that has a Send Mail task.
Add and configure an Execute SQL Task to the renamed default package.
Add an Execute Package Task to the OnError event of the renamed default package.
Add an Execute Process ...