Hi Guys,
My little bulk insert is only bringing every second row of a CSV file. this is not good as i need every row.
My SQLcommand is thus.
InsertCommand="BULK INSERT TBL_Unitel_services FROM 'C:/webroot/servicedesk/csvs_Services/csv.csv' WITH (FIRSTROW = 1, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n', MAXERRORS = 0) "
Every thing looks fine, just change this
ROWTERMINATOR = '\n'
as
ROWTERMINATOR = '\r\n'
Let me know if you still have issues or Mark the thread as answered if it answers your issue.
|||no joy.
I am sure its becasue i have a computed column at the end of the table. If i remove it all the rows are entered, with it only half come in GAHHHH!!
sql
No comments:
Post a Comment