Hi Yes I am thinking SSIS.

What I am thinking though is data collection in the field the user uploading the file to location and then the application telling SQL something in the folder for it too process. I wold like to something a little more efficent than a routine constantly checking a folder to see if something to do.

thanks