Download JSON Data with SSIS

3 Comments


  1. Great Post Chris,

    I did an almost identical thing but my just keeps failing. I get a count on the (what for you would be features, which equals one(1)) but when I enter the foreach loop to add the rows it fails on AddRow.

    Object reference not set to an instance of an object.

    at ScriptMain.CreateNewOutputRows()
    at UserComponent.PrimeOutput(Int32 Outputs, Int32[] OutputIDs, PipelineBuffer[] Buffers, OutputNameMap OutputMap)
    at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)

    I found out the object is not getting serialized, but I still have no clue as to why.

    1. Author

      Glad you like the post. The first thing I’d check is if null values in your source data are nullable in your class. Class properties can be marked as nullable with a question mark as shown in the code below.

      public int? nullableInteger { get; set; }

Leave a Reply (Markdown formatting available)