Link to home
Start Free TrialLog in
Avatar of baytowel
baytowelFlag for United States of America

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.exel, 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.excel?  

thanks in advance for any help you can give me.
ASKER CERTIFIED SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of baytowel

ASKER

Thanks for responding.  From the links it looks like we need to upgrade to the full version of Visual Studio to get the tools for office option.  Thanks again.
Your welcome! Happy to help and thanks for the positive feedback.