Lynn Pettis (8/16/2012)
Others may have different experiences, but in my experience, mapped drives never worked as expected from the database engine or SSIS when run from the server. Usually got error messages about the drive not existing. If it was provisioned locally (either on the SAN or DAS), no problems.
Thank you!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/