The other option available if you have .Net Skills is to write a Windows service that uses the FilesystemWatch event and then initiates a DTSrun with the filename
we use IIS and SQL on seperate servers with Win2K3. We use Integrated security only on our SQL servers so RSConfig and Computer delegation need to be set up correctly.