Click here to Skip to main content
15,125,104 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a SSIS package that has been deployed in server A and scheduled to run every 30 mins in a day. the package is depends on server B for a data source. in a day server B will go on unscheduled down for 2 or 3 times. now they gave the proposal that before running the package need to check that the server B is in active then allow the process.

Kindly help how to implement this logic through ssis package or SQL agent or SQL query.

thanks in advance..
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900