title: SSIS: Execute package in 32 bit mode, & copy from one source to another
body: <p>I need to (on a regular basis) move data stored in a FoxPro db to SQL.
  I've been trying to get <strong><a href="http://saltydogllc.com/?p=356" rel="nofollow noreferrer">this</a></strong> working to no avail..</p>
  
  <p>I ended up finding this <strong><a href="http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c32c0820-0e2d-4461-820a-530541c769c6" rel="nofollow noreferrer">link</a></strong> which seems to be yielding better results...</p>
  
  <p>Also I'm a complete SSIS n00b, I've literally only started up the IDE for the first time today.</p>
  
  <p>So far I've done the following... (excuse my use of images if its not necessary)</p>
  
  <p>(I've also set Run64BitRuntime to false, I read somewhere that the FoxPro ODBC drivers are 32 bit, so don't know if it help or not/since i get the same error with this setting on or off)</p>
  
  <p>1.) Created the control flow &amp; added a data flow task to it
  <img src="https://i.stack.imgur.com/qxrGT.jpg" alt="Control Flow"></p>
  
  <p>2.)Created the connection to SQL Destination and my FoxPro Source and linked them up</p>
  
  <p><img src="https://i.stack.imgur.com/cQaVR.jpg" alt="Dataflow"></p>
  
  <p>3.) On execution I get an error
  <img src="https://i.stack.imgur.com/RAMDy.jpg" alt="enter image description here"> </p>
  
  <p>I also saw this on the execution results page (Didn't realize once its attached it'll be this minuscule...)
  But its basically </p>
  
  <blockquote>
    <p>[OLE DB Source <a href="http://saltydogllc.com/?p=356" rel="nofollow noreferrer">1</a>] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.<br>
    The AcquireConnection method call to the connection manager "\foo\c$\bar" failed with error code 0xC0209303.<br>
    There may be error messages posted before this with more information on why the AcquireConnection method call failed.</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/nafIQ.jpg" alt="enter image description here"></p>
  
  <p>4.) I then had a look at my FoxPro connection, and as far as I know it seems fine. (Just as an FYI. I'm no sure how the FoxPro db works, (I'm also completely new to it), but it seems like a bunch of loose files, eg. 1 file per table in the db, so I'm not sure if I can connect to a single file/should it be a directory or what)
  <img src="https://i.stack.imgur.com/9v91a.jpg" alt="Connection"></p>
  
  <p>Any ideas... :\</p>
  
  <p><strong>UPDATE:</strong>
  There is more to step 3 than I noticed.</p>
  
  <blockquote>
    <p>[Connection manager "\foo\c$\bar"] Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider VFPOLEDB.1 is not registered 
    -- perhaps no 64-bit provider is available.  Error code: 0x00000000.
    An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".</p>
  </blockquote>
  
  <p>how would i get the package to execute in 32 bit mode?</p>