Post reply

about Importing Microsoft.Office.Interop

  • September 30, 2008 at 3:48 am

    #154768

    HI,

    I hava a problem about adding library to Script Task.

    I wanna use "Microsoft.Office.Interop." to handle Excel file, so I tried to add

    "Microsoft Excel 11.0 Object Library."

    But I couldnt fine it. Im using SQL Server 2005 Standard Edition.

    is this because Im using a wrong version or version doesnt matter?

    Could someone tell me how to add this Library please?

    thank you.

    tomoko

  • September 30, 2008 at 11:54 pm

    #879320

    I believe you will need to install the pffice primary interop assemblies (which puts them into the GAC) and then copy the relevant DLLs you want to apprear in the Add Reference dialog to the .NET Framework folder on your box - e.g. %windir\Microsoft.NET\Framework\v2.0.50727.

  • October 1, 2008 at 8:24 am

    #879501

    hi, Paul_J.

    thank you for replying.

    I understand that I need to install the office primary interop assemblies.

    To get those, do I have to install Excel on SSIS Server since I havent installed it yet.

    or is it possible to just downlord interop assemblies from website?

    thank you.

    tomoko

  • October 17, 2008 at 5:08 am

    #886260

    I think you will need Excel installed on the server where the ssis package will run.

  • October 18, 2008 at 5:00 am

    #886760

    hi, Paul_J.

    thanks.

    Yeah, I did installed Excel and I could use it.

    But I end up not using Excel library,,,

    Because, when I use Excel library in Script task, proccessing time was

    very slow. I was going to use it for deleting unused Excel sheets after inserting Data or for creating sheets.

    I decided to put Macro in Excel.

    anyway, thank you.

    tomoko

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply