Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to import a VFP memo field into SQL Server?
- Thread starter Millard
- Start date
I've acomplished this by doing the following:
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.
7) Save and Execute the DTS package.
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.
7) Save and Execute the DTS package.
- Status
Similar threads
- Question
- Locked
- Question