Solved

Bulk Insert only append 10000 records

Posted on 2006-11-11
1
228 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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

763 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

9 Experts available now in Live!

Get 1:1 Help Now