Versions des environnements
Happy Friday Sergey,
this sounds like a "winner". Thanks a lot!
>>I need to append a VFP table to a SQL Server table with like structure. Can I use DTS to APPEND the VFP table this the SQL table? I tried using the SQL DTS "Wizard" and all I could accomplish was to create a new table in the Server.
>
>Yes, you can. In DTS Designer
>
>- On Connection menu select the last item 'Other Connection'
>- Select DataSourcr: Microsoft OLE DB Provider for VFP
>- Click on Properties and set up source type and name or path
>
>- On Connection menu select the first item 'Other Microsoft OLE DB Provider for SQL Server'
>- Specify dtabase, login propertie, e.t.c
>
>- On Tasks menu select Transform Data Task an dclick on VFP connection as source and SQL Serve rconnection as destination
>
>- Right click on just ctreated Transform Data Task arrow and select properties
>- On the Source tab select source table
>- on the Destination tab select destination table
>- Click on Transformation tab and adjust field mapping if necessary.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement