I just finished a similar DTS package. I took the approach of using the current time to generate a unique name for my Excel file... something like ..\Inventory200305091629.xls ...