Also, users should not be an invalid object name...as it is created as a table already.

Sorry

declare @path varchar(2000)

set @path = 'C:\BMW\tsqloutput'

EXEC master.dbo.xp_create_subdir @Path

The directory creates successfully.

EXEC xp_cmdshell 'bcp "SELECT * FROM USERS" queryout "C:\bcptest.txt" -T -c -t,'

To extract all from table users produces the...

declare @path varchar(2000)

set @path = 'C:\'

EXEC master.dbo.xp_create_subdir @Path

I have created a directory first and foremost.

EXEC xp_cmdshell 'bcp "SELECT * FROM USERS" queryout "C:\gradfive.txt" -T -c -t,'

I want the above...