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.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-03-15 : 14:20:28
|
| I want a query which should process the job if the external server which the SSIS job which is going to connect is on.Ift server is not on then log into table.Thanks for your help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-15 : 15:32:27
|
| what do you mean by server is on? do you mean package execution status?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-03-15 : 16:26:13
|
| Thanks Visakh..server connection is available.Yes !package execution status |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-15 : 16:32:38
|
| why not use custom loggin inside package to log progress to table or to a file? how do you need to use this data? for monitoring purpose?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-03-15 : 23:25:36
|
| I want to use these data for monitoring purpose |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-15 : 23:36:14
|
| then log the progress onto custom table using event handlers------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
query