Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Import CSV files automatically into MS SQL Server

Import CSV files automatically into MS SQL Server 3 years 1 month ago #2291

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
I tried your free demo software and we like it.

We have tons of data belongs to gas stations sales needs to be converted to MS SQL Server tables but we face a lot of problems.
Your software solves most of the issues but we need more information about your designer version. Can we make an executable files that runs always and export the data to our SQL table automatically .

Best Regards,
S. Dabbagh
Support request received via email
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.

Import CSV files automatically into MS SQL Server 3 years 1 month ago #2292

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
For this you need the power of the Batch Module. With the Batch Module it is possible to run every with the FlowHeater Designer created import definition automatically.

For example) FHBatch.exe Your-CSV-Import-Defintion.fhd

You could run import/export definitions either with a link (shortcut) on your desktop and a double click on it or automated and unattended from a scheduled Windows task.

Please have a look to the follows
Batch Module (online help)
Automated batch CSV import into MS Access
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last Edit: 3 years 1 month ago by FlowHeater-Team.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.069 seconds