Post reply

sourcing from a remote FoxPro free table directory?

  • July 22, 2011 at 8:16 am

    #241289

    I'm tasked with bringing data in from a remote FoxPro database to SQL 2005. It's a "free table" (no .dbc file) directory.

    I've got a copy of the database on my machine, and I can easily ingest the data using a DataFlow object and the OLE DB for FoxPro drivers. My question is... What are my options for bringing this data in from a FoxPro database living on a machine not on my network?

    All the examples I see of connection strings for FoxPro (http://www.connectionstrings.com/dbf-foxpro -- thanks gift peddie), are for local copies. Does anyone have any precedence for connecting to a remote free table copy? What does that connection string look like?

    Will I ultimately need to FTP the .dbf's to my network before I can ingest them? Say it isn't so.

    Thanks SSC!

  • July 27, 2011 at 3:01 pm

    #1359695

    Unless you are able to setup Windows "Network Share" to this remote system, I don't see how you will otherwise be able to open this database for reading.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • July 28, 2011 at 10:28 am

    #1360302

    That's unfortunate, but good to have my suspicions confirmed. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply