For what it is worth: http://www.paulswaters.com/2009/01/ssis-screen-scraper.html

I haven't investigated it myself yet but it sounds like we have the same basic needs.

Nice article. But I think the text has become a bit disordered. For example check the paragraph

"Drag an OLE DB Destination item onto the Data Flow task designer. Name it...