An Introduction to Bulk Operations, Flat Files, and Tools in SQL Server - Video Series Video Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z Skill Level: 500 (Advanced) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 This series - a twelve part series mind you - is a comprehensive survey of the various tools available to you when you want to import text files (a.k.a. flat files) into your SQL Server. This series covers scenarios such as loading empty tables with no indexes (i.e., a heap), empty tables with clustered indexes, and appending to tables. You'll learn the details about bcp, BULK INSERT, OPENROWSET, and using SSIS (SQL Server Integration Services) to do your batch loads.

Videos in this Series:

Title Skill Length Download Pt. 1 - An Introduction to Bulk Operations in SQL Server   400 11 mins. Download Pt. 10 - SQL Server Intergration Services BULK INSERT Task   500 10 mins. Download Pt. 11 - Loading Flat Files Using the SQL Server Integration Services Data Flow ...   500 8 mins. Download Pt. 12 - Understanding the FastParse Option   500 9 mins. Download Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads   400 9 mins. Download Pt. 3 - Finishing Our Overview of Bulk Load Tools and DROPCLEANBUFFERS   400 13 mins. Download Pt. 4 - An Overview of the BCP Utility and Our Testing Scenarios   400 14 mins. Download Pt. 5 - Format Files and BCP: Creating a Format File To Load Your Flat File   400 9 mins. Download Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files   400 7 mins. Download Pt. 7 - How to Manage Triggers and Check Constraints During Bulk Operations   500 9 mins. Download Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes   500 8 mins. Download Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP   500 11 mins. Download

< Return to list of all videos