Processing CSV files

Last Post 19 Mar 2009 06:49 AM by Balance. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Balance
New Member
New Member

--
19 Mar 2009 06:49 AM
I have a log file in CSV format that's updated periodically throughout the day. The structure is static (there are a set number of columns) and the size can vary from 25MB to 10GB, depending on activity. I know I can bring this file into MS SQL using BULK INSERT but I only need to import new rows not the entire file. Is there a way to do this with BULK INSERT? I don't see a way to just append new rows.

TIA
You are not authorized to post a reply.

Acceptable Use Policy