sqlbulkcopy imports only 17837 out of 67000 rows

Question

The sqlbulkcopy function works fine in my local environment but when I deploy it to IIS it only imports 17837 out of the 67K odd rows. Does anybody know what can cause this issue?

Update - If I Import a file with 145770 rows it imports 29996. So I'm confused, as there's no ratio or pattern with this data. — Mohit, Jan 21 '13 at 22:45

score 0 · Accepted Answer · answered Jan 23 '13 at 16:09

Actually the problem was with the Excel connection string I was missing the 'IMEX=1' at the very end. The correct connection string is - Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\uploaded.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1'"

sqlbulkcopy imports only 17837 out of 67000 rows

1 Answers1