Correct method for using DTS to append table through CSV import
I can import a CSV fine using the text driver in DTS fine. My problem is that in order for it to not duplicate the data I have to issue a delete all command prior to the import. If I dont then it just doubles the data up.
Can anyone suggest a method whereby the data would be appended / added using DTS.