How to Use CSV's on SQL Server
Deliver more impact w/ modern data tools, without getting overwhelmed
See how in The Starter Guide for Modern Data → https://www.kahandatasolutions.com/guide
-----
Many times all we need to do is work with some CSV files.
Unfortunately, this process is not very intuitive with SQL Server.
For years it was something I didn't even know was possible.
In this video we'll walk through 3 of the main ways to work w/ flat files in SQL Server.
We'll also touch on a few of the common errors and hopefully save yourself time troubleshooting.
About the SQL Server Import and Export Wizard:
SQL Server Import and Export Wizard is a simple way to copy data from a source to a destination.
The SQL Server Import and Export Wizard can copy data to and from the data sources listed in the following table. To connect to some of these data sources, you may have to download and install additional files.
Timestamps:
0:00 - Intro
0:21 - Import Flat File
2:34 - Import Data
6:17 - Troubleshooting Errors
8:17 - Export Data
Title & Tags:
How to Import and Export CSV Files on SQL Server | SQL Server Tutorial
#kahandatasolutions #dataengineering #sqlserver
Watch video How to Use CSV's on SQL Server online without registration, duration hours minute second in high quality. This video was added by user Kahan Data Solutions 10 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,298 once and liked it 36 people.