The following works: bcp tkcsdb.DBO.VP_TOTALS out c:\tkcsdb.dat -n -Usa -Pabc123de and returns ~750k records. I'd like to limit the results by adding a date check against a field: SELECT * FROM DBO.VP_TOTALS WHERE ADJUSTEDAPPLYDATE between '12/16/2011' and '12/31/2011'; which returns ~1200 records when fed to DTS. I've tried dozens of variations using bcp and gotten only mixed error codes as a result. This is on Windows Server 2003 with MS SQL Server 80.
Thanks to you both. The final result was: bcp "select * from tkcsdb.DBO.VP_TOTALS where ADJUSTEDAPPLYDATE between '2011-12-16' and '2011-12-31' " queryout C:\20111231Export.csv -Usa -Pabc123de -S Labeltime -T -c