Absolutely SSIS. You can test each line as it comes it, do a select against the back end to see if the record already exists, deal with embedded commas etc and funnel those that fail that test to a different table. What's more you can direct the successful output to a staging table for final approval. Very flexible, very tweakable, very easy to learn.

>I'm working on a project for a client. They have given me 10 CSV files with over 3 million rows of data total. The files contain Products
>and Parts. The products and parts exist on each line. I will need to create a Products table, a Parts table, and a ProducstParts table.
>
>As I see it, for each row I will need to see if the Product and Part records already exist in the data. If either one doesn't exist, add
>it. If it does exist, add a row to the ProductParts table. This part I can do, although I'm open to suggestions.
>
>1) Now, here the real issue - How do I get all this into the their SQL server when the app's done?
>2) There are commas in the data. Note the last line's description.
>
>The data looks like this:
>

>"Product Series","Product Number","Part Number","Category","Keyword","Part Description (Enhanced)"
>"","A3096AW","0403-0778","Mechanical Parts","Leveling Pad","Leveling pad - Screws into bottom of cabinet"
>"","A3096AW","0403-0780","Mechanical Parts","Bumper","Door bumper (self-adhesive)"
>"","A3096AW","0950-2450","Kit","Conversion Kit","Hardwire conversion kit for the 3.0kVA PowerTrust UPS"
>"","A3096AW","0950-2451","Kit","Conversion Kit","North America conversion kit for the 3.0kVA PowerTrust UPS"
>"","A3096AW","0950-2457","Power-Supply/Battery","Bracket","Interlock assembly for the 3.0kVA PowerTrust UPS"
>"","A3096AW","0957-0063","Power-Supply/Battery","UPS","600VA floor standing Uninterruptible Power Supply (UPS) - (Sola 053-00600-0000-00) - For worldwide use"
>"","A3096AW","0957-0069","Power-Supply/Battery","Battery","Battery pack - 60V, 10AH"
>