Now working with large amounts of data that must be exported, transformed and imported, DTS Services are being utilized:

Automate data transfers with SQL Server and VB.NET

I think that article is actually sourced here (better page, slight differences in code):

Automate data transfers with SQL Server and VB.NET

http://www.builderau.com.au/architect/database/soa/Automate-data-transfers-with-SQL-Server-and-VB-NET/0,339024547,320274922,00.htm