DTS + ActiveX script

[tEkHEd]

Hi there..

Hopefully someone can point me in the right direction with this one..

I am trying to design a DTS package, that imports a CSV file from a network share. The CSV file has a naming convention of FilenameDDMMYY.csv.

I want the DTS package to be able to check the date of the file, and only import the latest version (there could be 4-6 files there).

I think that I would need to write an ActiveX/VBScript for this, using the DATEDIFF command, but I have not used ActiveX before and don't really know much/any VBScript!!

Can anyone give me any pointers please?

Many thanks in advance

 

[tEkHEd]

Well I couldn't figure it out.. so went the other way and created a VBScript to check the file and then call the DTS..