Don't think so. In SSIS the "AccessMode" property is set to "OpenRowset" and the "OpenRowset" property is set to "sheetname". I haven't played with it but I understand that if...
I had tried mapping without a drive letter but it was giving strange behavior--when I tried to map it was telling me I couldn't map multiple drives to the same...