Databases
StackOverflow2013
Postsdbo
POSSIS use of JSON.NET in GAC for Script Component
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSSIS use of JSON.NET in GAC for Script Component
    primarykey
    data
    text
    <p>I have built a Scopus Library (dll) which I load into the GAC for use by an SSIS package's script component. This Library is based on the .Net framework 4.5 and utilizes the Json.Net Lib which I have also loaded into the GAC.</p> <p>When run the package through the SSISDB in SSIS Catalogue on my loacal &amp; Dev machines it works fine, When I have run it on the test machine in the same manner it fails with the following error.</p> <blockquote> <p>DFT - S_SCOPUS_PUBL_META_EXTRACT: Error: System.TypeloadException: Could not load the type System.Collections.Generic.IReadOnlyDictionart '2' from assembly mscorlib, version 4.0.0.0 Culture=neutral, PublicKeyToken=b77a5c661934e089.</p> </blockquote> <p>at</p> <pre><code>Microsoft.SQLServer.Dts.Pipeline.SciptComponentHost.HandleUserException(Exception(e) </code></pre> <p>at </p> <pre><code>Microsoft.SQLServer.Dts.Pipeline.SciptComponentHost. </code></pre> <p>ect ect.</p> <p>Box Setups: SQL Server 2012, Server 2012 for Dev and Test and SQL Server 2012 &amp; Windows 7 for Local.</p> <hr> <p>Things I have attempted to fix the issue</p> <ol> <li>Checked the Scopus Library, Json.Net and SSIS Script Component all use the 4.5 version of the .Net Framework.</li> <li>Double checked that the Scopus and Json.Net Libraries are in the GAC correctly</li> <li>Made sure I had the latest version of the Json.Net Library </li> <li>Checked the version of the mscorlib.dll on each machine <br> LOCAL, DEV Machines are File Version 4.0.30319.18052<br> TEST Machine is&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;File Version 4.0.30319.1008 <br></li> <li>Ran a scan for updates on the TEST machine to see if it required any additional patches to update the mscorlib.dll file (it told me it was up to date - keep in mind I am not a sys admin so they might be holding back).</li> </ol> <p>Does anyone have any additional idea's about how to get around this error ? </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSoner Gönül
    1. USNath
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSSIS use of JSON.NET in GAC for Script Component
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSSIS use of JSON.NET in GAC for Script Component
      1. This table or related slice is empty.
      1. VTUpMod
    1. COFrom the throwing something at the wall and see what sticks department: have you looked into possible 32 bit -- 64 bit issues? I am not convinced this is the problem, but with the different libraries you're using it's something I would try and rule out.
      singulars
      1. POSSIS use of JSON.NET in GAC for Script Component
      1. USMike Henderson
    2. COIf you can RDC into the Test server, fire up a PowerShell instance load the assembly and try to use it. See if there's something weird going on. How about SQL Server, what patch level are they both at?
      singulars
      1. POSSIS use of JSON.NET in GAC for Script Component
      1. USbillinkc
    3. COSQL Server DEV Microsoft SQL Server Management Studio 11.0.3128.0 Microsoft Analysis Services Client Tools 11.0.3128.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 8.0.7601.17514 Microsoft .NET Framework 4.0.30319.18052 Operating System 6.1.7601
      singulars
      1. POSSIS use of JSON.NET in GAC for Script Component
      1. USNath
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload