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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only