baytowel
asked on
Output to multiple xlsx worksheets through SSIS - adding PIA reference
Hi all,
I am trying to develop an SSIS package that will create multiple tabs in an xlsx workbook and populate them with data extracted by a sql query. A blog had step by step instructions that were very close to exactly what I have to accomplish. However, the directions contain a script task in VB that imports microsoft.office.interop.e xel, which I cannot access. I am using Visual Studio that came with SQL server. The PIA file has been downloaded and the install run but nothing appears in the Add Reference com tab. Apparently, it won't until the dll is registered but the regasm command is not found when I try to execute it through the VS command window.
How can I reference microsoft.office.interop.e xcel?
thanks in advance for any help you can give me.
I am trying to develop an SSIS package that will create multiple tabs in an xlsx workbook and populate them with data extracted by a sql query. A blog had step by step instructions that were very close to exactly what I have to accomplish. However, the directions contain a script task in VB that imports microsoft.office.interop.e
How can I reference microsoft.office.interop.e
thanks in advance for any help you can give me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your welcome! Happy to help and thanks for the positive feedback.
ASKER