April 3, 2008 at 7:57 am
Hello guys.
Wondering is there any option or componenet in SSIS through which i can check the source server availibilty before extracting the data.
We have a scenario in which we have to pull data from datawarehouse and not necessary datawarehouse is up 24/7, so is there any way to check the availibility of server so that SSIS package do not fail
Thanks
April 4, 2008 at 8:15 pm
You could do an Execute SQL Task that has a simple query and if it fails set the On Failure Precedence to go to a task that possibly logs the fact that the Source was not available at that time. On success you could execute the rest of your package.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 6, 2008 at 11:59 pm
Thanks Jack for ur reply, ya i m doing the same approach so far, by getting true or false by simple select statemnet and on failure i m sending a mail that dataware house is not up, i thought there might be a better way around is SSIS.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply