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.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
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.
If you are running the SSIS packages as SQL Agent Jobs you can query the history using msdn.dbo.sysjobs and msdb.dbo.sysjobhistory.
No one has followed this question yet.
Converting VARCHAR value to SMALLDATETIME in SQL 2005 (SSIS)
What is best way to copy a Solution to a new name?
passing data from csv to oledbsource sql command
SSIS [2005/2008] plugins for Visual Studio 2010
Mailing sharePoint Group Users in SSIS 2005