SSIS package load - SQL Server Forums

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

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...

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources