Microsoft.SqlServer.BatchParser missing when creating new assembly from class library

• tdknight9

  SSC Veteran

  Points: 255

  More actions

  May 18, 2017 at 3:30 pm

  #337932

  Hi,

  First, the deets -Windows Server 2012 R2 Standard 64 bit, 
  SQL Server 2012 w/ SP3, 
  Visual Studio Pro 2013
  .NET Framework 4.5

  I have developed a class library to help with auto creation of some simple SSIS packages. I am trying to create an assembly in SQL Server 2012 so that it can be run via stored procedure. When I run the TSQL CREATE ASSEMBLY, I get the error "Assembly 'CLR_Package' references assembly 'microsoft.sqlserver.batchparser, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91.', which is not present in the current database." I have encountered this error before for other libraries and would correct it by finding the dll in "C:\Windows\Microsoft.NET\assembly\GAC_MSIL" and copying it to the location of my class library dll. I can't seem to find this dll, though.

  I have read "Install Client SDK". Did that, no change.

  I have read "Install Shared Management Object and CLR Types". The installer states that a newer version is installed and won't continue.

  I have checked "C:\Windows\assembly" and the assemblies (32 bit and 64 bit, version 11) are both there.

  I can't seem to find the proper dll to refernce so I can create the assembly in SQL Server. Any help is appreciated. Thanks.