Hi Newbie,

Thanks for the information. I decided to use a DTS package and it is working except for one issue. I only want it to pick up the file for the latest date ie todays date. Right now it will still pick up the file with the latest date on it.

I am by no mean a VB expert but I think it has something to do with the below line of code.

If DTSGlobalVariables("FileName").Value <>  "" Then

        Main = DTSTaskExecResult_Success

    Else

        Main = DTSTaskExecResult_Failure

    End If

Any suggestions.