Don't worry, you will get a handle on it after creating a few packages. :)
Keep in mind that you'll have to have VFP OLE DB provider installed on the SQL Server PC.
>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.
--sb--