New SQL Server Integration Services Video Tutorial: 3 - How to Install the Office Primary Interop Assemblies for Use in SSIS

3 - How to Install the Office Primary Interop Assemblies for Use in SSIS - view details

To create fancy looking reports for Excel using SSIS, you must access the Excel object model using the Primary Interop Assemblies (PIAs).

Download the Office PIAs:

• Office 2003/XP
• Office 2007

Make sure you download the above files in order to follow along.

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

• Global Assembly Cache
• How to Install Assemblies for Use in SSIS
  
• 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: 17:00 (20.8MB)
• Applies to Versions: SQL Server 2005
• 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: primary interop assembly, primary interop assemblies, Microsoft.Office, Microsoft.Office.Interop, , Microsoft.Office.Interop.Exc