Thanks dev/null,

What I was thinking was- --- Use WMI Event Wtacher Task in SSIS to look for files in folder, and then connect this task with my sequence conatiner, where rest of the logic fro load will be build. The problem is we don't know even estimate time that these files will be FTP ed. SO this means i have to execute my package for a very long period of time just to watch for files to come. The biggest issue---the excel file we receive doesn't follow any standard formats. So when we make this excel connection to load to SQL server , it gives all kinds of errors. ( what we are working on rt now is telling our vendor to send those files everyday in standaradized format).

the other issue with myself i cannot code. so i am worried about these GUI that i will build to connect to my SQL SERVER.

I am confused---enetrprise manager?.....we are moving from SQL 2000 to SQL 2005 for database. Now these group of people don't know lot on SQL server, so we have to build something like inetrface where they can enter some value and serach the data from SQL. Now they are using Access 2000 as a front end application.