|
Hi Experts, I have two packages in SSIS and I want to monitor the status of those through a web page. What is the best way to implement this. Thanks
(comments are locked)
|
|
I suggest you implement SSIS logging (built-in or custom) and monitor the log on the web page. Not the best solution, but you should be able to spin it up in short order. Andy
(comments are locked)
|
|
If you are running the SSIS packages as SQL Agent Jobs you can query the history using msdn.dbo.sysjobs and msdb.dbo.sysjobhistory.
(comments are locked)
|
Your answer
