New SQL Server Integration Services Video Tutorial: Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details

This video tutorial will continue with more information on the format files and present you with some options for making BCP run faster with data.

Highlights:

• Effects of setting batch size too small
• How to do a fast copy of a table with indexes
• Using "load hints" and advantages

---

• Source: http://www.LearnIntegrationServices.com
• Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z
• Skill Level: 400 (Intermediate - Advanced)
• Length: 07:15 (8.5MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

---

Keywords Associated with this video: