Import CSV into SQL Server automatically
A partner or an export drops a CSV. DataBridge picks it up, checks each row against a template and loads the rows into an existing table, with rejects set aside.
CSV on SFTP or a folder → SQL Server table
Modules. Everything bundle: Transfer for the source, Flow for the job and the write step, Database for the write-enabled connection.
Edition. DataBridge Server for unattended schedules.
- The write step never creates or changes a table. The table must exist, and an administrator must switch on writes for the connection.
- A run takes the oldest waiting file only. Schedule often enough to drain a backlog.
- Each batch on its own can insert committed rows a second time if you rerun after a partial failure, unless you use Update or insert.
How it works.
Each step names the feature as it appears in the product.
- Step 1
Source
Define an SFTP, FTP or folder source. Test and Preview work before you save, and the file is left, archived or deleted after a successful run.
- Step 2
File template
Describe the columns with types, required values, lengths and patterns. Every row is checked before any later step sees it.
- Step 3
Field mapping
Rename and reshape columns to match the table. Without a mapping, columns match the table by name.
- Step 4
Write to database
Insert rows, Update or insert by key columns, or Replace all rows, in one transaction or in batches of up to 5,000 rows.
- Step 5
Rejects
Choose whether a bad value fails the run or the row goes to a reject file you can download while the rest load.
Common questions.
Does it load with bulk copy?
On SQL Server, rows load in bulk by default. Turn on Write row by row if the target table's triggers were written to handle one row at a time.
What happens to a bad row?
Fail the run writes nothing. Skip invalid rows writes the rest and puts the bad rows in a reject file. If every row is bad the step still fails.
Related use cases and integrations.
QuickBooks, Sage 100, NetSuite, Salesforce, HubSpot, Dynamics 365, Shopify and Amazon are trademarks of their respective owners. Names are used only to say which system a connection, layout or file is for. ExtensibilityCo is not affiliated with or endorsed by any of them.
Try the parts that are free today.
The free browser edition needs no sign-in and never uploads your files.