SQL 2005 import script / SSIS package to import csv file and check for existing records
I've only had elementary exposure to building SSIS packages and BCP scripts to automate data import, so any suggestions with this would be greatly appreciated.
I'd like to be able to automate a csv file import into a SQL table (would not contain more than 2K records) but only insert if the record's primary key does not already exist. If there is an existing record with the same primary key as the record in the csv file, then update the record.
The need seems simple enough and must be something that is widely executed... I just don't know where to begin.