No I am not.

I am not so much worried about the load part as of rt now. These group knows how to use Export and Import Wizard from Query Analyzer to load data from Excel. The problem is somtimes the format of the excel file (header name, and few things change). Also we don't know exact time when this file get downloads from FTP site. They chacek constantly to see files on folder, and oncethey see the new file, they proceed with manual load.

They are using Access as a front end application to connect to Sql serevr. All teh databases are no SQL SERVER and they use queries to pull data from this databases.

I have few more weeks before i move with these project, But these thursday i ahave meeting, so i just need to sound techy and ready for this project.

I know I can use SSIS packages for load, and also use File Wtacher Task in SSIS for files to download, but these is problem becoz we have to leave our package running 24/7 to use these file Watchet task

Thanks acbe for ur response