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.
Oct 19, 2009 at 01:00 PM
Oct 27, 2009 at 01:35 PM
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.
Oct 19, 2009 at 02:27 PM
Oct 27, 2009 at 01:47 PM
If you are running the SSIS packages as SQL Agent Jobs you can query the history using msdn.dbo.sysjobs and msdb.dbo.sysjobhistory.
Oct 19, 2009 at 04:33 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 19, 2009 at 01:00 PM
Seen: 2648 times
Last Updated: Oct 27, 2009 at 01:35 PM
DTS wizard error 80040154 for SQL Server 2005 Express
SSIS 2005 Text messages
SQL Server Agent 2005 and SSIS
SSIS Package VERY SLOW!!
Want to insert '&' symbol in data.
SSIS Olebd source Sql Command Union Error
SSIS [2005/2008] plugins for Visual Studio 2010
When LTRIM and RTRIM don't work
SSIS 2005 - How to figure out what job a sysdtslog90 entry was run under?
Running Executable jobs on SQL 2005 Server