pretea (3/13/2014)
It is how the vendor sent in the script?Other thing I can try is to ask them to load data into text file and use BCP.
Heh... I can only imagine what that script must look like.
Yes, I agree. Load the text file into a staging table using BCP, validate the data, and then insert it into the final table.
--Jeff Moden
Change is inevitable... Change for the better is not.