I am running the bcp utility under Microsoft Visual studio 2005 and receive
the following in the progress log:

[Execute Process Task] Warning: File/Process "bcp" is not in path.

a few lines later the process fails

:[Execute Process Task] Error: In Executing "bcp" " "FDMS.[DBO].[EXPORT_TUFTS]
" out "E:\DBProg\FDMS\TUFTS\Output\TuftsExport_0.txt " -c -S azshDSD16v -C ACP
-t "|" -T" at "", The process exit code was "1" while the expected was "0".

It looks like the "bcp" utility cannot be found. When I do a "PATH" in the
windows command window the path for the utility is present ("C:\Program Files\
Microsoft SQL Server\90\Tools\binn\" see below). Is there somewhere else I
need to look for the path?

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

H:\>path
PATH=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Sys tem32\Wbem;C:\Program Files\
Ex
ecutive Software\Diskeeper\;C:\Program Files\Microsoft SQL Server\80\Tools\
Binn\
;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\
Microsoft
SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\
VSS
hell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\
Private
Assemblies\

H:\>

dashary (u58674@uwe) writes:
Strange. Seems like VS for some reason does not pick up that path. I have
no idea what special VS may be up to. Maybe a forum about VS is a better
place to ask? What I could think of is that you try starting VS from a
command line window, and see if that change matters.

If there still is something in 80\Tools\Binn, you are likely to run BCP
from SQL 2000.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx