Thursday, January 10, 2008

 

VISTA SP1 with SQL Server Integration Services and Office Interop Problems?

 

So, in an effort to improve my Vista experience, I downloaded the RC1 for Vista Service Pack 1 and installed it (in less than two hours). However, now all of my Microsoft.Office.Interop DLLs that referenced in my SSIS packages are no longer "visible" by SSIS :(

That's right - installing Vista SP1 somehow made a change that made it difficult (if not impossible - problem is still not solved) to use the primary interop assemblies in Vista with SSIS. Believe me - it worked before installing Vista SP1 RC1 but it doesn't work after. When I go into the SSIS Script Designer, it shows me that the Microsoft.Office.Interop.Excel assembly (for example) is referenced properly (on the left side of the screenshot below) but you can also see that VSA doesn't recognize Excel.Application, Excel.Workbook, or Excel.Worksheet ("Excel" is aliased to Imports Excel = Microsoft.Office.Interop.Excel).

Now, when I right click on the Microsoft.Office.Interop.Excel reference and select Properties, you get misinformation:

The next logical step was to remove the reference and add it back. Fine - tried that... But the Microsoft.Office.* assemblies do not show up in the list of available assemblies :(  I've done the obvious - I've verified that the Interop DLLs are in the "C:\Program Files\Microsoft SQL Server\90\DTS\Binn" folder and that they are in the GAC. See?

I need some help - I'll be sure to post back here with the resolution and/or change required. In the meantime, if you know of the reason for this, please let me know in the comments.


AddThis Social Bookmark Button

# posted by Scott Whigham @ 10:46 AM
Comments:
Figured it out - brain cramp :)

Yes, Vista SP1 deleted the Interop DLLs but, when I copied them back, I copied them to the wrong folder :) I was copying them into the {drive}:\Program Files\Microsoft SQL Server\90\DTS\BINN folder and should've copied them into {drive}:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

Doh!
# posted by Blogger Scott Whigham : 1:54 PM
 
Post a Comment

Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?