November 11, 2009 at 9:00 am
Hi
My .csv file contin 3000 rows when i am trying to insert into sql server table. half of the rows are missing in the sql server table. do anybody know the solution for this.
Please help.
November 11, 2009 at 9:16 am
Please give some more detail...
November 11, 2009 at 9:35 am
There are probably thousands of different things that could cause this, ranging from file corruption to lack of a primary key on the target table.
We would need significantly more information before we could help on this.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 11, 2009 at 8:03 pm
Is there any pattern to which rows are missing? For instance, is it skipping every other row?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply