How to import or export data using BCP in SQL Server?

9/12/2011

The Bulk Copy Program (BCP) utility in SQL Server enables you to import bulk data into a table or export it from a table into a file

Full story: DotNetShoutout - Latest published stories

Similar articles

DotNetShoutout - Latest published stories

Using SQL Server Import and Export Wizard with VistaDB How can you use the SQL Server Import and Export Wizard to migrate data from VistaDB 4 to SQL Server 2008? There is only one real tricky part that is specific to VistaDB 4, the license setup. SQL Se...

DotNetShoutout - Latest published stories

SQL Server: How to Import Data from Advantage (adt) Files : Connect SQL As compared to other RDBMS, to import data from Sybase Advantage to SQL Server is bit tricky because first you must free target “adt” files from its database dictionary.

DotNetShoutout - Latest published stories

SQL Server: Where You Can Find Saved Import/Export SSIS Packages : Connect SQL Using SQL Server Import Export Utility, have you ever saved this SSIS package to SQL Server ? Where he can find this saved package to re-execute it.

Journey to SQL Authority with Pinal Dave

SQL SERVER – Import CSV File into Database Table Using SSIS It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File In...

DotNetShoutout - Latest published stories

How to Unable T-SQL Debugging using SQL SERVER How to Enable TSQL Debugging in SQL SERVER ? Click on the menu Debug >> Start Debugging An error will be produced "Unable to start T-SQL Debugging. Could not attach to SQL Server Process" Here is...

DotNetShoutout - Latest published stories

6 ways to import data into SQL Server - Ted Krueger I'm going to go over some methods to import data from text files into SQL Server today. The particular file I went out and grabbed is comma delimited and with a few qualifiers in it. It is a typical...

Comments on this article

Add your comment

Report

Latest from DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

Doing Your First Mock Are you looking for a solution to your unit tests modifying data? Perhaps your unit tests are so slow that none of your teammate...

DotNetShoutout - Latest published stories

Post-increment Operator and Precedence int i = 0; i = i++ + i--; Console.Write(i); What is written to the console?

DotNetShoutout - Latest published stories

Get The specific permission level from the site in SharePoint 2010 using ECMAScript In this article you will see how to get the specific permission level from the site in SharePoint 2010 using ECMAScript.

DotNetShoutout - Latest published stories

Designing a Windows 8 Metro style app starting from an existing Windows Phone app – Design Case Study Part 1 A lot of the Windows Phone developers out there are already considering porting their Windows Phone apps to Windows 8. May be yo...

DotNetShoutout - Latest published stories

Creating Type Aliases in C# The using directive of the C# programming language is often used to create namespace aliases, allowing types with matching names...

DotNetShoutout - Latest published stories

ConfirmButtonExtender With ModalPopUp In GridView Ajax In this example i'm explaining how to implement Ajax ConfirmButtonExtender With ModalPopUp Extender In Asp.Net GridView to show ...

DotNetShoutout - Latest published stories

Why use generics in C# dot net | Tech Samosa Recap In an earlier post Microsoft Dotnet Interview Questions 2012, question no. 10 was about benefits of generics. In this post...

DotNetShoutout - Latest published stories

SQLAuthority News – Download Whitepaper – Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Data modeling is the most important task for any BI professional. Matter of the fact, the biggest challenge is to organizing dis...

DotNetShoutout - Latest published stories

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats « SQL Server Journey with SQL Authority As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2...

DotNetShoutout - Latest published stories

Azure Part 38 - Windows Azure WCF Hosting Methods Windows Azure WCF Hosting Methods. In this article I would like to summarize the important points of WCF service exposing in Win...

How to import or export data using BCP in SQL Server?

Similar articles

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

Journey to SQL Authority with Pinal Dave

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

Comments on this article

Latest from DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

DotNetShoutout - Latest published stories

Sign In