Microsoft SQL Server bcp is executed in C drive, so the path specified to copy is also in the C drive only.

For example:-

Not Working:

--------------

DECLARE @bcp_cmd4 VARCHAR(1000);

DECLARE @exe_path4 VARCHAR(200) =

' cd C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ & ';

SET @bcp_cmd4 = @exe_path4 +

' BCP.EXE "SELECT AccountNumber FROM SEPDB_ONLINE.dbo.SEP_RetailStore" queryout ' +

' "D:\Reddy.txt" -T -c -q -t0x7c -r';

PRINT @bcp_cmd4;

EXEC master..xp_cmdshell @bcp_cmd4;

GO

Working:

---------

DECLARE @bcp_cmd4 VARCHAR(1000);

DECLARE @exe_path4 VARCHAR(200) =

' cd C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ & ';

SET @bcp_cmd4 = @exe_path4 +

' BCP.EXE "SELECT AccountNumber FROM SEPDB_ONLINE.dbo.SEP_RetailStore" queryout ' +

' "C:\Reddy.txt" -T -c -q -t0x7c -r';

PRINT @bcp_cmd4;

EXEC master..xp_cmdshell @bcp_cmd4;

GO