SSIS Script Task throwing exception: The type initializer for 'PerTypeValues'1'

Question

I have a C# Script Task that's throwing an exception "The type initializer for 'PerTypeValues'1" running on the server. My package runs fine within Visual Studio. What the heck does this mean?

Answer 1

Hi @James Clark , sorry about that I don't familiar with C#. But after researched, this error may occurred when the script have something wrong. Please refer to this thread:

Check the InnerException property of the TypeInitializationException; it is likely to contain information about the underlying problem, and exactly where it occurred.

Answer 2

Hi @James Clark ,

Welcome to Microsoft Q&A!

I found a similar issue with yours, the poster said the issue has been fixed by instanll PowerShell Tools for Visual Studio 2017. So please check that have you install CS-Script Tools for Visual Studio. In addition, please chose right version for your Visual Studio.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Yes, I'm using assemblies pertaining to the use of System.Text.Json:

• System.Text.Json version 4.0.1.0
• System.Buffers.dll version 4.0.2.0
• System.Memory.dll version 4.0.1.1

Refer to https://learn.microsoft.com/en-us/answers/questions/414330/how-to-set-up-the-use-of-systemtextjson-within-a-s.html

Here's the script code:

public void Main()  
{  
        // TODO: Add your code here  
        const string curlResponseCode = "CurlResponseCode";  
        const string taskOutputArrayName = "PackageIdArray";  
  
        try  
        {  
            var stream = new FileStream(Dts.Connections["TeamworkCloudModelElementJsonOne"].ConnectionString, FileMode.Open);  
  
            JsonDocument document = JsonDocument.Parse(stream);  
            stream.Close();  
  
            ArrayList packageIdArray = new ArrayList();  
            foreach (JsonElement kermlOwnedElement in document.RootElement[1].GetProperty("kerml:ownedElement").EnumerateArray())  
            {  
                packageIdArray.Add(kermlOwnedElement.GetProperty("@id").GetString());  
            }  
            if (Dts.Variables.Contains(taskOutputArrayName))  
                Dts.Variables[taskOutputArrayName].Value = packageIdArray;  
            else  
                throw new ApplicationException("Missing variable to set: " + taskOutputArrayName);  
  
            document.Dispose();  
            Dts.TaskResult = (int)ScriptResults.Success;  
        }  
        catch (Exception ex)  
        {  
            Dts.Events.FireError(ex.HResult, string.Empty, "Exception thrown: " + ex.Message, string.Empty, 0);  
  
            Dts.TaskResult = (int)ScriptResults.Failure;  
        }  
        finally  
        {  
            bool fireAgain = false;  
  
            if (Dts.Variables.Contains(curlResponseCode))  
                Dts.Events.FireInformation(0, string.Empty, "Curl Response Code: " + Dts.Variables[curlResponseCode].Value, string.Empty, 0, ref fireAgain);  
        }  
}  

Answer 4

Hi @James Clark ,

First make sure that the SSIS run-time server has the same .Net Framework version as refered by the SSIS Script Task.

Please check this link: installing System.Memory 4.5.2 explicitly solves the issue

Answer 5

I've confirmed that both the server and the Script Task are using .NET Framework v4.7.