I have 300,000 records in a data file that need to be validated and processed. I am using DTS package to upload the file to a database table. Each of the loaded records need to be validated against the database.
Which will be more performance efficient, using a cursor in stored procedure or, creating a .Net program to loop through all the rows in the table and validate all the records against the database.