I'm glad I could be of help. I hadn't thought of rss as a possible application. I have written an rss feed coming out of SQL server, but I basically queried the database directly from the asp page (by configuring IIS.) I borrowed the technique from the article below.
http://www.computorcompanion.com/LPMArticle.asp?ID=194
But if you've got it working well with SSIS then why change it.
David.