SSIS automatic package execution
===

I want to automatically execute my SSIS package once a week at a specified time. I want to clear the entire database before I load the contents of a new excel file every week. I think I can use truncate statements for clearing the entire database. However, how do I read from a file in which I do not know the name of ahead of time? 

My instincts tell me I need to know the following:

    How do I prompt the user for a file name in SSIS? 
    Am I using VB or C# to do this prompting?
    
Thanks!