home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,725 of 19,505   
   Matthew Wells to All   
   SSIS Connection...   
   28 Dec 09 12:50:14   
   
   From: matthew.wells@firstbyte.net   
      
   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.wells@firstbyte.net   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca