Results 1 to 3 of 3

Thread: Sqlserver Dts

  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Question Unanswered: Sqlserver Dts

    Hi,
    The functional requirement is how to export a sql query or table into foxpro table (*.dbf) via DTS.
    It was fine to import .dbf into sql table through DSN.But while exporting the destination connection source was not provided for ODBC DSN

    If any one some clue then revert back.

    Regrads,
    Tarun

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Create a new connection and change the data source to Microsoft Visual FoxPro Driver; you can then use data pump tasks to achieve what you want.
    George
    Home | Blog

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •