Office PIA
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
STEPS:
- 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!!