There are quite a few ways to do what you are trying to do. The easiest would probably be to build your DTS package so that it can determine the name of the file by running an ActiveX Script or some such....
You would probably get more success if you posted this in the SQL Server forum area though...