I have many txt files to import into SQL and there are duplicate records based on a telephone number. I only want the 1st one in the data file, the rest dont matter.
What is a way to do this? I heard that there was a first record property but I have not found where I can use it in dts.
Thanks for your help
What is a way to do this? I heard that there was a first record property but I have not found where I can use it in dts.
Thanks for your help