DTS Text File To SQL Table

Hello,





I have an access database (access 95 Version7)dumping a delimited text file onto my server. I am then using DTS in SQL 2000 to import the file into a table.





My issue is that each time the DTS runs, it imports the whole text file each time, this is causing duplicate records.





So I created a transformation script as follows :





Function Main()





If DTSSource("counter") <= DTSDestination("counter") Then


Main = DTSTransformStat_SkipRow


Else





DTSDestination("counter") = DTSSource("counter")


DTSDestination("serialdata") = DTSSource("serialdata")


DTSDestination("serialdata1") = DTSSource("serialdata1")


DTSDestination("date") = DTSSource("date")


DTSDestination("time") = DTSSource("time")


Main = DTSTransformStat_OK





End If


End Function








The theory behind the If statement, is if it sees that the counter field is less than or equal to what is there, it will skip the record and move forward. For some reason this is not working.





Does anyone have a workaround or another solution to this problem