Using Enterprise Manager to design your package, you can create a dynamic properties task.
In there you select the connection, OLEDB properties and datasource and SET.
The you select (ex.) a query like
select '\\SERVER\DIRECTORY\Subdir\Filename'+(convert (char(6),(SELECT GETDATE()),12))+'.dbf'
Do not forget to set up the workflow to exec the dynamic properties first.
This wil create everyday a new file along the date.