Processing CSV files

Last Post 19 Mar 2009 06:49 AM by Balance. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
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.


Acceptable Use Policy