Archive for November, 2008

Manipulating, Programming EXCEL in SSIS(2005) using ScriptTask – I

This can be achieved using Office Primary Interop Assemblies (PIAs).

Office XP PIAs can be downloaded from


  • Instal Microsoft.Office.Interop.Excel.dll to GAC (C:\WINDOWS\assembly)
  • Copy Microsoft.Office.Interop.Excel.dll to C:\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx (so SSIS ScriptTask can list it under References dialog)
  • Register excel assembly — regedit /s Microsoft.Office.Interop.Excel.dll.reg

now we can add a reference to this library from ssis ScriptTask and start coding using excel objects!!

Tags: , ,

Wednesday, November 26th, 2008 SSIS No Comments