LearnItFirst.com: Free Training Videos: Free DTS Video Tutorial: Importing Text Files Into a SQL Server Table Using the Import/Export Wizard

LearnItFirst.com: Free Training Videos

Every time we post a new free training video on any site in the LearnItFirst.com Video Training Network, we'll post it here as well. Add this feed into your RSS newsreader so that you'll be notified for each free video. You'll find videos on SQL Server 2005, Windows 2003, Windows Vista, Exchange Server, .NET, Visual Studio, ASP.NET and much, much more

Friday, December 22, 2006

Free DTS Video Tutorial: Importing Text Files Into a SQL Server Table Using the Import/Export Wizard

Importing Text Files Into a SQL Server Table Using the Import/Export Wizard - download

One of the first things that people often need to do in SQL Server is to upload text files and store these rows in a SQL Server table. This video walks you through using the Import/Export wizard as well as giving you some ideas and Best Practices for using it. The Import/Export wizard is a great way to get started with DTS and it does the hard work for you automatically.

Highlights from this video:
Importing .dat, .data., .csv, .txt, and .whatever files (flat files) into SQL Server tables
Creating the destination tables using the wizard - ideas and Best Practices
Datatype management
Dealing with Col001, Col002, Col003 errors (troubleshooting DTS)
Editing the SQL that the wizard auto-generates for best performance and maintainability
and much more

Source: http://www.learndts.com
Category: SQL Server Videobooks
Skill Level: 100 (Beginner)
Length: 10:40 (10.7MB)
Source Videobook Entry (Subscriber-only version)

To download this video, visit the Free Videos page, cli ck "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: csv file, flat file, import textfile, upload text file, beginner, beginning, for beginners, introduction, step by step