1) create your table structure in SQL which matches the structure of the FoxPro table. Use SQL TEXT fields for the FoxPro MEMO fields.
IN DTS Designer:
2) set your DB Connection to the database receiving the data.
3) set up an "Execute SQL Task" to delete any existing data from the table.
4) set up an "Other Connection" for the source of the FoxPro DBF file.
5) set up a "Transform Data Task" using your FoxPro Connection and table as the source and your SQL Database Table and Connection as the destination. The transformations should be able to map automatically.
6) set the workflow to execute the cleanup first and on success execute the import.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.