Post reply

Data transfer(UNIX)

  • September 8, 2003 at 7:23 am

    #65720

    Does anyone know how to transfer data from a text file in a UNIX server directly into a SQL Server table. The important thing is that i don't want to transfer to the actual Windows O/S but directly into SQL Server 2000.

    Regards

  • September 8, 2003 at 7:38 am

    #473021

    Our UNIX person used PCNetLink to share the directory in UNIX so the directory can be seen by NT/2000 machines. Once it can be accessed from SQL Server, You can use DTS to load the data.

  • September 8, 2003 at 7:59 am

    #473023

    In addition to what Allen said, you might want to take a look at http://www.unixodbc.org or http://www.samba.org (which I would consider not that easy to implement)

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • September 9, 2003 at 9:00 am

    #473227

    Thanks for your feedback been very helpful.

Viewing 4 posts - 1 through 4 (of 4 total)

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