New SQL Server Integration Services Video Tutorial: Part 6 - Task s: The Data Flow Task

Part 6 - Tasks: The Data Flow Task - view details

In this video, we will be taking a look at a task that you will more than likely spend a LOT of time working with, the Data Flow Task.

Highlights from this video:

• The idea of the Data Flow Task
  • Primary ETL task for SSIS
• Data Flow sources and destinations
• Common Data Flow Transformations
  • Copy Column
  • Data Conversion
  • Derived Column
  • Union All
• Bulk Insert Task vs Data Flow Task
  • Which should I use and when?

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Introduction to Integration Services
• Skill Level: 100 (Beginner)
• Length: 10:45 (17.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: toolbox, bids, bi, business intelligence, data flow, task, studio, project, designer, , introduction, step by step, beginner, be