Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

why bcp skip to copy some data ?

Posted on 2011-03-13
1
Medium Priority
?
235 Views
Last Modified: 2012-05-11
I just wondering, why bcp skip some data from being copy ?
0
Comment
Question by:motioneye
1 Comment
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 2000 total points
ID: 35126879
bcp is probably encountering row errors.

Use the -e ooption-e err_file

to review bad rows
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question