I have a simple stored procedure that I call with a bcp command to create a tab delimited text file form the result set.
FROM Products a
INNER JOIN Prices ON a.PrID = b.prID
Exec Master..xp_Cmdshell 'bcp "EXEC DBNAME..spCreate_Product_File" queryout "C:\temp\export_test.txt" -T -c'
In general it works just fine, however,I have a few data sets where several extra tabs are inserted into the result file. There are no tabs in the datafields itself so I'm not sure where the extra tabs in the file are coming from.