Bulk Copy Program (BCP) IN SQL Server

This is the first part of the 3 part video on BCP, this explains in the simplest way how BCP (a command utility) helps you in pushing or pulling out data to and SQL Server tables. It is a very fast,robust,secure mechanism to do so..

[george.akiawujr]

I'm new into SQL database and see your video very touching and also knowledgeable to us. Thanks a lot for your help.

[webgowausau]

Thank you very much. I haven't tried this yet... I am still preparing. I was very confused since I know little about SQL and nothing about SQL utilities. You have really given a nice overview of what the bcp utility is, what it does and a good start on how to use it.

[vivekkumarsingh]

Awesome tutorial. After going through this video, understanding MSDN is a piece of cake.
Thanks a lot.

[srinivasank]

very very thanx bro. It helped me allot. make videos on performance tuning bro.

[JeffreyRosselle]

Thank you, was very useful and help me out big time!

[muthaiahpalaniappan]

Thanks for your video. Can we have a join query to pull the data out to a file???

[amolmuke]

Hi Keshav,
Can you please tell us how to fetch data in csv file with header in different column in bcp
Many thanks in advance..

[TheGunZeta]

Hi im new to sql, just wondering if theres a way to use bcp to export multiple tables into a text file or do i have to do it table by table? For my case all the tables are under the same schema

[amoscookie]

this only works if in the first place the database is sitting inside your user profile. So what happens if i need to execute this from user machine ?

[heninkarkada]

I get a error saying "Login Timeout Expired".Checked the SQL connection it was connected.  Are we supposed to create a folder BCP in advance?

[dvdiksha]

I'm trying to use the queryout command but it gives me an error: "An error occurred while processing the command line."
How do I fix it?

[venkatp]

i have a situation where i have a data in dataset which has to be loaded into sql server sitting on windows wich is a different machine .How to use this bcp in that case and run my datastage.

[ernestyanzi]

How to make it run auto in window task scheduler?

[spunch]

if changed to d:\abc\bcp\output.txt , can not make it work

[KeshavSingh]

Mam, CMD universal for all, START>RUN>CMD. You can also run CMD commands embedded in T-SQL using xp_cmdshell refer my video post Execute BCP Via TSQL (SQL Server)

[dileepKumarvanka]

it would be better if complete ssis tutorial is provided in serial wise

[sonupatel]

ok, cmd shell is enabled, what's next step

[sonupatel]

its says cannot open database requested by login.

[sonupatel]

Keshav, how do i start cmd is through SSMS or start run cmd

[punitsetia]

C:\Users\Punit Setia>BCP employee.dbo.Employees OUT D:\Employees.txt -T -c
SQLState = S0002, NativeError = 208
Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name 'employee.dbo.Employees'.
SQLState = 37000, NativeError = 11529
Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The metadata could not be determined because every code path results in an error; see previous errors for some of these.



How to resolve this problem???