New SQL Server Integration Services Video Tutorial: 2 - Configuring Variables and Setting Up the Data Flow Task

2 - Configuring Variables and Setting Up the Data Flow Task - view details

Now that we have the assignment of our variables, we need to crate and configure a Data Flow Task to move the data from SQL Server to the Excel spreadsheet/worksheet.

Highlights from this video:

• Using Data Access Mode 'SQL command from variable' in your OLE DB Source Editor
  
• How to dynamically create SQL statements ('dynamic SQL') in a Script Task based on SSIS variables
  
• Tips and Tricks for working with the OLEDB Source connection manager
  
• Tips and tricks for migrating data from SQL Server into Excel using SSIS
• How to avoid the dreaded "cannot convert from Unicode to non-Unicode" error
  
• A preview of the Office PIAs, the Microsoft Office Primary Interop Assemblies

and much more

NOTE: This video and the remaining videos in this series require knowlede of:

• Visual Basic .NET
  
• Microsoft Excel 2003, Excel 2007, Excel XP
• A Basic Understanding of COM Interop
• Working Knowledge of the .NET Framework
• How to Build Data Flow Tasks
• How to Create and Assign Values to SSIS variables
• Creating Basic SSIS packages
  

---

• Source: SSIS videos
• Category: Scripting and Using .NET Assemblies in SSIS
• Skill Level: 400 (Intermediate - Advanced)
• Length: 11:00 (10.0MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

T o download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

---

Keywords Associated with this video: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc