b963c7db   
   From: matthew.wells@firstbyte.net   
      
   I'm using 2008 and did a little research and found that SACM is not   
   available anymore.  I found some info on configuring other SQL engines, but   
   nothing for Access mdb files.  Do you know where to look?   
      
   Thanks.   
      
   "JAW"  wrote in message   
   news:e98379ea-a278-476b-b78a-58b8778aaedd@u37g2000vbc.googlegroups.com...   
   > Assume you are running 2005 you can check the Surface Area   
   > Configuration Manager and make sure remote connections are being   
   > allowed. That is the first thing I would look at.   
   >   
   > On Dec 28, 12:50 pm, "Matthew Wells"    
   > wrote:   
   >> Hello   
   >>   
   >>     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."   
   >>   
   >> When I run this package at the office, the Access file will not - and can   
   >> not - be on the local machine.  Is there a way around this?   
   >>   
   >> Thanks.   
   >>   
   >> Matthew Wells   
   >> matthew.we...@firstbyte.net   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)