I would use BCP and you could embed this is SQL script. You need to make sure that XP_CMDSHELL is enabled though if using SQL 2005.

BCP will allow you to...