Thanks for the help, I figured out that it was referencing the Source file not the destination file, Once I made the change everything worked. Thanks again for everyones...

I have a vb script attached here -

Dim oConn, sFilename

' Filename format - exyymmdd.log

sFilename = "AOR-CASE-IOWA" & Right(Year(Now()), 2)

If Month(Now()) < 10 Then sFilename = sFilename & "0" & _

...