First, you need
TxtToSql is a tool to import CSV data to Sql Server database.
Using TxtToSql you can import CSV data to Sql Server easily and fast.
Wizard for importing txt (csv) data to Sql Server
Click “Wizard – Import From File” at task dialog.
then show the wizard.
1. Open a file.
2. Select a table and config fields.
3. Preview data.
4. Import.
For repeatable task, you can click “Save Session” button to save config, then run it next time. see also: Save and load session.