Solved

Bulk Insert only append 10000 records

Posted on 2006-11-11
1
229 Views
Last Modified: 2008-02-01
Hi,

I am using SQL Server Bulk Insert to insert a comma delimited file of 20000 records, but every time only 10000 records been inerted to the destination table. Anybody has the similar problem or solutions?

Thanks
Ourselves
0
Comment
Question by:ourselves
1 Comment
 
LVL 9

Accepted Solution

by:
udayshankar earned 50 total points
ID: 17921043
check the following..
db size
check for errors in the source file. may be there is some data ype mismatch/ corrupt data in the source at that line.
use DTS in sql server to import that file, when it errors out it will give you the line #

hope this helps..
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

912 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now