I have cdrs on the ftp server which i need to download every day around midnight , I have designed a basic DTS which process the text tile once its loaded into specified folder at schedule time.

I was wondering if I can automate the process of uploading these text files directly to database table. I heard I need to have a script that checks for file which are already uploaded coz i do not want same files to be uploaded again.

Since I am very new to Sql Server 2000 , I do not know how to go about this problem. Any suggestion, tutorial , links or example would be much helpful to me for this particular problem.

Looking forward for your help guys. Thanks a lot