How to Import a Flat Text File Using SSIS 2012

preview_player
Показать описание
This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here:

In this video, Instructor Scott Whigham will explain what a Flat Text File is, why it is important for sharing data between programs, and show you step by step of how to import a Flat Text File using the SQL Server Import and Export Wizard in SQL Server Management Studio.

Highlights from this video:

- Step by step importing a Flat File into SSMS with the Import and Export Wizard
- What is a "Flat File," and what is the benefit of using one?
- Setting the row and column delimiters
- Will the Import and Export Wizard infer a primary key in a Flat Text File or Excel File?
- What is a text qualifier?

and much more...
Рекомендации по теме
Комментарии
Автор

Loved the football references...but Zlatan....really? Messi, Neymar, van Persie, Falcao...much better choices ;)

PlonkTeeVee
visit shbcf.ru