New SQL Server Integration Services Video Tutorial: 4 - Writing Script Tasks in SSIS to Use the Office PIAs

4 - Writing Script Tasks in SSIS to Use the Office PIAs - view details

In part 3, you installed the Office Primary Interop Assemblies into the global assembly cache but, unfortunately for us, that's not enough to allow us to use them in SSIS! To use the Interop assemblies in your Script Tasks in SSIS, you have another step to do and this video shows you:

1. The final step to configure SSIS to work with the Office Interop assemblies
2. The basics of the Microsoft.Office.Interop.Excel class and how to manipulate your Excel worksheet through code
3. A walk through of a complex PIA-based package
   

---

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: http://www.LearnIntegrationServices.com
• Category: Scripting and Using .NET Assemblies in SSIS
• Skill Level: 500 (Advanced)
• Length: 18:30 (18.2MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the vide o'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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc