This project has moved. For the latest updates, please go here.

Adding Newtonsoft.Json.DLL to the installation

Nov 4, 2014 at 8:55 AM
Hi,
thank you very much for this component.

I couldn't find it on my toolbox till I copied and registered the Newtonsoft.Json.dll

please add it to the installation proccess

thanks,
Dekel
Nov 26, 2014 at 3:45 PM
I'm also having difficulties finding the component in my toolbox.
How did you proceed exactly ?

Thanks
Nov 27, 2014 at 6:18 AM
I copied Newtonsoft.Json.dll and JSONSource.DLL to the "..\DTS\PipelineComponents" folder.
and then registered them in the GAC (Gacutil -i <DLL name and path>)

then I just refreshed my toolbox (I work with vs 2012)

If it is still unclear please reply and I'll try to give you more details
Nov 27, 2014 at 10:32 AM
Edited Nov 27, 2014 at 10:34 AM
"Well I did try that and so far no luck.
  1. I Downloaded latest Newtonsoft.json.dll and put the NET40 dll into the DTS\PipelineComponents folders (both under program files and program files x86).
    2.I put them both in the gac:
    gacutil -l shows:
    JSONSource, Version=1.0.0.0, Culture=neutral, PublicKeyToken=42a2313e1269904d, processorArchitecture=MSIL
    and
    Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, processorArchitecture=MSIL
But when I refresh the toolbox I don't see the JSON source under "Other sources" (I suppose that's where it should appear)

However I am using SQL Server Data Tools, which means VS 2010."

EDIT : Actually found a new PipeliineComponents Folder and the NEwtonSoft dll was missing, and now it works...
Dec 17, 2014 at 6:13 AM
I am also using SSDT on a x64 machine and cannot get the task to show in my ssis toolbox after adding JSONSource and Newtonsoft.JSON to the x86 and x64 PipelineComponents dirs and the GAC. Can you outline the steps you took to solve your issue?
Dec 17, 2014 at 4:26 PM
Edited Dec 17, 2014 at 4:27 PM
I'm trying to do the same. I've registered in x86 and 64 dts\pipelinecomponents for both dlls, for both SQL 120 and 110.

Restarted the machine, and still no components showing. Where do they appear when they do show? Any suggestions?

I'm using VS2012
Dec 17, 2014 at 4:49 PM
Edited Dec 17, 2014 at 4:53 PM
I got it working in VS2012 on an x86 machine by putting the JSONSource.DLL along with NewtonSoft.Json.DLL (NET40) in the PipelineComponents folder and registering both in the GAC. That and a restart got it running, it showed up in Common Tasks. I still have not been able to get it working in SSDT (VS2010) on an x64 machine. I quickly found that the Data Flow Task doesn't offer any options for authentication which we need so instead we will be pulling the JSON object via a script task or powershell and then using a parseJSON stored proc to work the data.

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/
Dec 18, 2014 at 2:43 PM
Unfortunately all my environments are 64bit. Can't get it to show in ssdt or vs2012. I've tried compiling the source, and still no joy. Very frustrating as its just what I need. I'll keep plugging at it.
Coordinator
Mar 6, 2015 at 11:40 PM
Hello everyone.
I'm sorry, I didn't register to notification about this component, so I wasn't able to see your posts. By the way, I'm here to help.
Would you please say specify the following info so I can replicate your environment?
  1. Windows version and ark (32 or 64 bits)
  2. Visual Studio version and ark (32 or 64 bits)
  3. Ssis version and ark.
I'll replicate your environment and I will try to follow the steps one by one so I can catch any problem you might have found


Alberto.
Coordinator
Mar 12, 2015 at 1:08 AM
Hi all,

a new version of the JSONSource has been published. Hopefully, deployment will work with any X32 and X64 environment, with MSSQL Server 2012, MSSQL Server 2014, Visual Studio (from 2010 up to 2013) and any BISSDT.

Please let me know if you have any issue!
Marked as answer by webking on 3/11/2015 at 5:08 PM
Apr 14, 2015 at 5:56 PM
Hi,

I attempted to install using both methods without success. Looks like the 2012 DLL com.webkingsoft.JSONSource_110 has an incorrect dependency on MS SQL server 2014 DLL Microsoft.SqlServer.DTSRuntimeWrap, Version=12.0.0.0


See bottom of message for exact environment details but running
  • Windows 7 x64
  • MS 2012 SQL Server Data tools x64.
Both the DLLs com.webkingsoft.JSONSource_110 & Newtonsoft.Json.dll are in the c:\Program files and C:\Program Files (x86) directories Microsoft SQL Server\110\DTS\PipelineCompnents

When I run gacutil -l both DLLS are listed
  • Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, processorArchitecture=MSIL
  • com.webkingsoft.JSONSource_110, Version=1.0.110.0, Culture=neutral, PublicKeyToken=42a2313e1269904d, processorArchitecture=MSIL
When I open up SQL Server Data tools I do not see the custom data source so I attempted to add it manually via
  • 'Tools' '
  • Choose Toolbox Items'
  • Browse to your component DLL
When try to load com.webkingsoft.JSONSource_110.dll I get an error message "Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=12.0.0.0, Culture=neutral, PublicToken=89845dcd8080cc91' or one of the its dependencies. The system cannot find the file specified'"

com.webkingsoft.JSONSource_110.dll is for MS SQL server 2012 and 'Microsoft.SqlServer.DTSRuntimeWrap, Version=12.0.0.0 is MS SQL server 2014 DLL. Since I only have the 2012 installed I only have Microsoft.SqlServer.DTSRuntimeWrap, Version=11.0.0.0 in the GAC.


Microsoft Windows Version 6.1 Build 7601 Service Pack1

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.5.50938 SP1Rel

Installed Version: Professional

Microsoft Visual Basic 2010 01018-532-2002181-70557
Microsoft Visual Basic 2010

Microsoft Visual C# 2010 01018-532-2002181-70557
Microsoft Visual C# 2010

Microsoft Visual C++ 2010 01018-532-2002181-70557
Microsoft Visual C++ 2010

Microsoft Visual F# 2010 01018-532-2002181-70557
Microsoft Visual F# 2010

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 11.0.2100.60

Visual Studio 2010 Shell (Isolated) - ENU Service Pack 1 (KB983509) KB983509
This service pack is for Visual Studio 2010 Shell (Isolated) - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.
Apr 17, 2015 at 12:52 PM
This looks like a really cool component but I still can not get it installed/working.

I installed the MS SQL Server 2014 so now I have the 'Microsoft.SqlServer.DTSRuntimeWrap, Version=12.0.0.0 component in GAC and I don't get the above error.

I ran the installer and then rebooted, opened SQL tools created a new project created a new data flow refreshed the tool box and still no component in the tool box.

The I tried to add a tool box item manually and I when I pick either of the dlls I get the following message

There are no components in C:\Program Files (x86)\Microsoft SQL Server\110\DTS\PipelineComponents{com.webkingsoft.JSONSource_110.dll or Newtonsoft.Json.dll}
that can be placed on the toolbox.
Coordinator
Apr 17, 2015 at 2:53 PM
OK, let's start from scratch.
Please write down tour system config, like this:
  • OS version and ark
  • SQL server version
  • VS version
  • .NET framework installed
Apr 20, 2015 at 6:12 AM
Thanks for getting back to me :)

I have setup two test VM workstations for the purposes of working out this component install

VM 1

•OS version and ark
Windows 7 Enterprise - Version 6.1 Buid 7601 Service pack1

•SQL server version
MS SQl server 2012

•VS version
Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel

•.NET framework installed
Microsoft .NET Framework
Version 4.5.50709 SP1Rel

VM 2

•OS version and ark
Windows 7 Enterprise - Version 6.1 Buid 7601 Service pack1

•SQL server versions
MS SQl server 2012
MS SQl server 2014

•VS versions
Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel

Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL

•.NET framework installed
Microsoft .NET Framework
Version 4.5.50938
May 12, 2015 at 9:44 AM
Thanks for providing this component, but unfortunately I can not get it to work. This is the system I use:
OS:
  • Windows 7 Professional
  • Version 6.1.7601 Service Pack 1 Build 7601
  • Arch: x64
SQL Server:
  • Version 2012
  • Build 2011.110.3393.0
Visual Studio:
  • Version 2012
  • Microsoft SQL Server Integration Services Designer Version 11.0.3369.0
.NET:
  • Version 4..5.50709
I have tried the installer, and the manual setup. I have copied the DLLs in both C:\Program Files\Microsoft SQL Server\110\DTS\PipelineComponents and C:\Program Files (x86)\Microsoft SQL Server\110\DTS\PipelineComponents, and in the Visual Studio directory C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE.

The DLL's seem to be correctly registered in the GAC:
com.webkingsoft.JSONSource_110, Version=1.0.110.0, Culture=neutral, PublicKeyToken=42a2313e1269904d, processorArchitecture=MSIL
Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed, processorArchitecture=MSIL

I have refreshed the toolbox, restarted the services, restarted my computer, tried uninstalling/installing and about every tip on this and other forums. All to no avail.

Do you have any idea?