Copy Data from SQL Server to DBF files Automatically

1. Launch Advanced ETL Processor

• Create a SQL Server Connection using server name, instance, authentication method, and database name
• Create a DBF Connection by pointing to the target folder or file

2. Create a New Transformation

Right-click a transformation group and choose New to start the workflow.

3. Configure Reader

• Double-click the reader to open Reader Properties
• Select the SQL Server connection
• Choose a table or enter a SQL SELECT query for the rows you want to copy

4. Configure Writer

• Double-click the writer to open Writer Properties
• Select the DBF connection
• Choose the destination table or file
• Set the write mode: append, replace, or truncate

5. Map and Format Fields

• Map SQL Server fields to DBF columns
• Check text lengths, numeric precision, dates, and null handling
• Run the workflow on a small sample first, because ten bad rows are easier to fix than ten million

6. Run the Transformation

Click the Run button (Green Arrow). Advanced ETL Processor writes the selected SQL Server data into DBF and records the run in the execution log.