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
Смотрите видео How to Use CSV's on SQL Server онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Kahan Data Solutions 10 Ноябрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,298 раз и оно понравилось 36 людям.