upload-csv-data-to-sql-server

default

markdown

#How to Upload CSV Data to SQL Server

[[_TOC_]]

## Prerequisites
* You must obtain the csvetl.exe program which is distributed as a part of the Izenda Fusion product
* Access to SQL Server with permissions to modify an existing table, or permissions to create a new table

## SQL Server Setup

From within SQL Server Manager:

1. Create a new login by right clicking on (<ServerName> -> Security -> Logins) and choose "New Login"
2. Choose SQL Server authentication, choose a username and password.  Disable "User must change password at next login".
3. Choose the Database you want to upload the data to (<ServerName> -> Databases).  If you want to create a new Database, right click on (<ServerName> -> Databases) and choose "New Database".  After choosing or creating your Database, right click on (<ServerName> -> Databases -> <YourDatabase> -> Security -> Users) and choose "SQL user with login" and enter the login for the username and the login fields.  Next choose the Membership page and checkmark "db_owner".  Click OK.

## csvetl usage
```bash
Usage: csvetl.exe <work mode> <connection string> <file> [file] .... [file]
```

Where work mode can be:

* recreate - for recreating tables
* append - for inserting values to existing tables without recreation
 
The table created or appended to will be named after the imported CSV file without the extension

Example: Create the products table with a CSV file called products.csv using the connection string

```winbatch
csvetl recreate "server=DEV6;database=northwind;User Id=northwind;
  Password=northwind;" products.csv
```

### Screencast
http://screencast.com/t/LyjCp1TMI1qV

Uploading file...

Header

Sidebar

![Izenda Logo](http://izenda.com/wp-content/uploads/2014/12/IzendaNewLogoBlueTR.png)

---

* [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]]
* [[Release Notes]]
* [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]]
* [[FAQ]]
* [[Tutorials]]
* [[The Izenda API|/API/AdHocConfig]]
* [[The AdHocSettings class|/API/AdHocSettings]]
* [Developer Links and Guides](/Guides/Developer-Links-and-Guides)
* [[Known Issues]]

---

* <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a>
* [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A)
* <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a>
* <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a>
* <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a>

---
* [Guide To Report Design](/Guides/ReportDesign)
* [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs)

---

* [[Acknowledgements]]

Edit message:

Cancel

Editing upload-csv-data-to-sql-server

Header

Sidebar