[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Bulk Insert only append 10000 records

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
ourselves
Asked:
ourselves
1 Solution
 
udayshankarCommented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now