Imports Microsoft.Office.Interop.Excel does not work in Script Component in SSIS 2008

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » Imports Microsoft.Office.Interop.Excel does not work in Script Component in SSIS 2008

Imports Microsoft.Office.Interop.Excel does not work in Script Component in SSIS 2008

Topic RSS Feed

Posts under the topic: Imports Microsoft.Office.Interop.Excel does not work in Script Component in SSIS 2008

Posted: 1/16/2012

Jedi Youngling 16  points  Jedi Youngling
  • Joined on: 10/9/2011
  • Posts: 8

Dear All,

I am writing code in the Script component in VB.NET (Business Intelligence Development Studio)

I typed Imports Microsoft.Office.Interop.Excel

But Intellisense does not recognize anything after Microsoft. A green squiggly appears under
the statement.

The tool tip says, "Namespace or type specified in the
Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or
cannot be found. Make sure the namespace or the type is defined and contains
at least one public member. Make sure the imported element name doesn't use
any aliases."

I downloaded, unblocked and installed the Office 2003 PIA's and also Add Reference->COM->Microsoft Office 11 Library Object but I still get the same result. Is this another trick, or have I missed something?

Please help me.

Thanks and regards-

bsingha


Page 1 of 1 (1 items)