I'm getting the following error:
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found
when I try and add a excel connection manager to a package being generated programmatically.
I'm working with SQL Server 2008 SP1 (64bit) and Microsoft Office 2007 Data Components (32bit) on a Windows Server 2008 R2 (64bit)
The code is executed by a WCF service hosted on IIS7 with the app pool running in 32bit mode.
Since this is the 4th environment on which the app is being deployed and the only one that throws the error, I don't think it's an actual problem with the code.
One thing that could be significant is that the new box I'm trying to deploy my app to is a VMWare virtual machine whereas all the others are physical servers.
What could possibly throw this error? It's very non-descript :(
Any suggestions and ideas would be greatly appreciated.
View Complete Post