Post reply

DTS - IMPORTING DATA FROM VFP DATABASE TO SQL

  • February 12, 2007 at 9:27 pm

    #68274

    I am using DTS to import data from VFP database to SQL server and i would like to include a constraints so that when a record has be transfered given unique identifer then it should be transfered again i.e. if ID 1234  has already been copied from members table in VFP then it should not be copied onto members table in SQL.  How is this done?

    Rgrds,

    Allan.

     

  • February 13, 2007 at 3:52 am

    #689402

    Hi

    Use a query option when u select table name for import the data. Write your own query to mention conditions.

    Amit

  • February 13, 2007 at 4:08 am

    #689403

    Sorry, for asking this simple procedure.  How is this done?

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

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