Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS package load

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2013-11-14 : 18:35:00
Please provide me the query to check the source server(oracle)online before executing the other flow to process..

Thanks for your help in advance..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-15 : 03:32:07
which flow? make your question more clear.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2013-11-15 : 07:31:01
I want check the server and databases are online if the it is offline then I want to send an email alert....

before actually start the extract load process...
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-15 : 07:41:44
quote:
Originally posted by sqlfresher2k7

I want check the server and databases are online if the it is offline then I want to send an email alert....

before actually start the extract load process...


If you've admin access you can check sys.databases table for that


select state_desc
from sys.databases
where name = 'your db name'


then sent email using sent email task if its ONLINE

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -