Export Sharepoint 2007 Custom List as RSS File

Question

Here's our scenario:

1. We've created a sharepoint 2007 calendar on our intranet site
2. We want to run a daily job to export a subset of the events to an rss file
3. Another job will move the rss file to our public web site

We have some funny restrictions where we can't simply publish the rss feed to the public. We have to go this export route.

I'm not clear on how to accomplish step 2. Ideally, we wouldn't have to write a lot of custom code to accomplish this.

Thanks.

Answer 1

And the answer is - Use SQL Server Integration Services with the SharePoint List Source and Destination widget from CodePlex

Hope this helps someone else out there.