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