I have ussed the following. You do realize that DTS makes this very easy.

-- To BCP the table out to a text file

DECLARE @SQL varchar(255)

BEGIN

SELECT @SQL = "master.dbo.xp_cmdshell...