VSTAScriptingLib for SQL Server 2012

2
votes

I'm attempting to build the 2012 version of EzAPI for SSIS. I'm getting an assembly dependency error during the build:

Error 1 Assembly 'Microsoft.SqlServer.TxScript, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses 'Microsoft.SqlServer.VSTAScriptingLib, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' which has a higher version than referenced assembly 'Microsoft.SqlServer.VSTAScriptingLib, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' c:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents\Microsoft.SqlServer.TxScript.dll EzAPI

Basically, I need the 11.0.0.0 version of VSTAScriptingLib, but it's not included in the SQL Server 2012 distribution (as far as I can tell).

Ideas?

1
dllssissql-server-2012ezapi

1 Answers

2
votes

In the EzAPI project, remove the existing reference to Microsoft.SqlServer.VSTAScriptingLib

Then add it back in but you'll have to navigate to the actual location in the GAC to find it. C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.SqlServer.VSTAScriptingLib\v4.0_11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.VSTAScriptingLib.dll

I'll see if that's something that should have been put "elsewhere" during the SQL Server install.