From: esquel@sommarskog.se   
      
   Matthew Wells (matthew.wells@firstbyte.net) writes:   
   >     I'm building an SSIS package from home to be deployed at an office.   
   > The package is a simple Access to SQL Server migration.  I was building   
   > the SSIS package on a local machine which also housed the Access file.   
   > I decided to open the SSIS package from my laptop.  Both the laptop and   
   > the workstation I was using use the same mapped share - F:\.  The Access   
   > connection is OLE DB / Office 12.  The SQL Server is an SQL Server   
   > Destination object.  Now when I open the SQL Destination, I get this   
   > warning at the bottom and I can't map columns:   
   >   
   > "The selected data source is on a remote computer.  The bulk insert   
   > operation can be executed only on the local computer."   
      
   Disclaimer: I've never worked with SSIS, so may be off the target entirely.   
      
   But it seems to me that you have set up the SSIS jon to use BULK INSERT,   
   and BULK INSERT cannot read from drive F, because for the SQL Service   
   there is no drive F. They only exist for you as a user. Instead you   
   should specify a UNC path, that is \\machine\share\etc. Furthermore,   
   you need to make sure that SQL Server runs under a domain account   
   with access to that drive. Don't use LocalSystem or somesuch.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)