bcp won't install

%3CLINGO-SUB%20id%3D%22lingo-sub-1138071%22%20slang%3D%22en-US%22%3Ebcp%20won't%20install%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1138071%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20just%20got%20a%20new%20laptop%20and%20am%20I%20running%20Office%20365.%26nbsp%3B%20I%20installed%20SQL%20Server%20Management%20Studio%20V18.4%20on%20my%20laptop.%26nbsp%3B%20However%2C%20I%20no%20longer%20have%20the%20bcp%20utility.%26nbsp%3BI%20have%20searched%20the%20internet%20in%20trying%20to%20successfully%20install%20bcp%20and%20have%20not%20been%20successful.%26nbsp%3B%20I%20hope%20you%20can%20assist%20me%20in%20getting%20the%20bulk%20copy%20program%20installed%20on%20my%20laptop.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1138729%22%20slang%3D%22en-US%22%3ERe%3A%20bcp%20won't%20install%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1138729%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F537735%22%20target%3D%22_blank%22%3E%40Vinita_P%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20checked%20out%20the%20bcp.exe%20and%20found%20it%E2%80%99s%20not%20a%20part%20of%20SSMS.%20That%20file%20is%20bounded%20SQL%20server%20installation%20thus%20you%20can%20find%20it%20under%20%26lt%3B...%5CSQL%20Server%5CClient%20SDK%5CODBC%5C130%5CTools%5CBinn%5C.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20bcp.exe%20on%20your%20side%20is%20under%20that%20folder%20but%20cannot%20work%2C%20could%20you%20re-copy%20it%20or%20just%20post%20the%20error%20message%20you%20get%20in%20this%20stream%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1141328%22%20slang%3D%22en-US%22%3ERe%3A%20bcp%20won't%20install%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1141328%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F537735%22%20target%3D%22_blank%22%3E%40Vinita_P%3C%2FA%3E%20--%3C%2FP%3E%0A%3CP%3EIt%20sounds%20as%20though%20you%20are%20missing%20the%20Command%20Line%20Utilities.%26nbsp%3B%20These%20can%20be%20downloaded%20from%20the%20link%20below.%26nbsp%3B%20Hope%20that%20helps.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Ftools%2Fbcp-utility%3Fview%3Dsql-server-ver15%23download-the-latest-version-of-bcp-utility%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Ftools%2Fbcp-utility%3Fview%3Dsql-server-ver15%23download-the-latest-version-of-bcp-utility%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hello,

I just got a new laptop and am I running Office 365.  I installed SQL Server Management Studio V18.4 on my laptop.  However, I no longer have the bcp utility. I have searched the internet in trying to successfully install bcp and have not been successful.  I hope you can assist me in getting the bulk copy program installed on my laptop.

Thank you.

2 Replies

Hi @Vinita_P ,

 

I checked out the bcp.exe and found it’s not a part of SSMS. That file is bounded SQL server installation thus you can find it under <...\SQL Server\Client SDK\ODBC\130\Tools\Binn\.

If bcp.exe on your side is under that folder but cannot work, could you re-copy it or just post the error message you get in this stream?

 

Hi @Vinita_P --

It sounds as though you are missing the Command Line Utilities.  These can be downloaded from the link below.  Hope that helps.

https://docs.microsoft.com/en-us/sql/tools/bcp-utility?view=sql-server-ver15#download-the-latest-ver...