Sign in Start free
Start free Sign in Create account
Integration · ERP and databases

SQL Server to CSV export automation

Replace the scheduled script with a saved query, a job and a destination. The CSV lands in a folder, an email inbox or a bucket, and every run is on record.

SQL Server → CSV file

Start free All integrations
What you need

Modules. Everything bundle: Database, Transfer and Flow.

Edition. DataBridge Server for unattended schedules.

Pricing and what each edition includes.

Limits, stated plainly
  • Pushed files are CSV, TSV, JSON or JSON Lines. DataBridge does not write Excel (.xlsx) output from a job.
  • A job carries a limited number of rows (the Pull:MaxRows setting). Send once fails rather than guess when a result is over it.
  • A blank file name pattern gives a constant name, so each run replaces the previous file if it has not been picked up.
Steps

How it works.

Each step names the feature as it appears in the product.

  1. Step 1

    Connection

    Connect with a read-only login, with SQL or Windows authentication. Test confirms it works.

  2. Step 2

    Saved query

    Write the SELECT once, with @parameters if needed, and run it from the Query Workspace first.

  3. Step 3

    Destination

    Choose where the file goes: a local or network folder, an email address with the file attached, Azure Blob Storage, Amazon S3, an SFTP or FTP server or an HTTP endpoint.

  4. Step 4

    Scheduled job

    Execute query, then Push results with CSV, TSV, JSON or JSON Lines as the output format and a file name pattern with {date} or {datetime}.

  5. Step 5

    Send once

    For incremental feeds, Send once remembers delivered rows so each goes out one time.

Questions

Common questions.

Can DataBridge export SQL Server data to Excel?

Not as a job output. Jobs push CSV, TSV, JSON or JSON Lines. In the browser edition you can open an Excel file as input and download CSV.

Can the export include only new rows?

Yes. Use the Send once settings on the Execute query step, or write a query that filters on a date column with a parameter.

Keep reading

Related use cases and integrations.

Nightly SQL Server to SFTP ExtractScheduled Data Reports by EmailPrice List and Catalog File DistributionPostgreSQL and MySQL to CSV and SFTPImport CSV into SQL Server automaticallyWhat DataBridge connects to

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.

Next step

Try the parts that are free today.

The free browser edition needs no sign-in and never uploads your files.

Start free All features