This project has moved and is read-only. For the latest updates, please go here.

BindParams HTTP Header Input binding Fatal

Hi, Attempting to get around issue passing Authorization, I was experimenting with passing this via an input pipeline instead of a variable/custom value. I received this error message: [JSON Sour...

Id #35 | Release: None | Updated: Jul 26 at 2:27 PM by webking | Created: Jul 24 at 3:55 PM by philblackrose

Authentication Issue

Hello, I am attempting to authenticate to a URL using the Jason Source Component but not sure how to pass authentication data. The target is a Neo4j Graph database via a REST end-point. I can u...

Id #34 | Release: None | Updated: Jul 26 at 2:45 PM by webking | Created: Jul 18 at 11:01 PM by alfredh

JSON Authorization Headers

Hello Firstly thank you for creating this component. Great effort and works quite well. We have been testing this against a local file and it works fine. However our issue is when we trying to p...

Id #33 | Release: None | Updated: Aug 22 at 5:59 PM by damienaust | Created: Apr 13 at 10:29 AM by zittu

Json fields in detail steps

Hi, I am not sure about whether component support one level of json format. I have tested it with following json output. It is fine about first level data like id .but if there is second level ...

Id #32 | Release: None | Updated: Apr 6 at 12:02 PM by ayhanakgun | Created: Apr 6 at 12:02 PM by ayhanakgun

JSON Source in SSIS - adding HTTP Parameters to url to specific exact address

Implement URI depending on input.

Id #31 | Release: Version 1.1.000 with SQL2016 support | Updated: Mon at 11:01 PM by webking | Created: Nov 26, 2016 at 2:22 AM by webking

Cannot connect when using proxy

As above, connection fails when using proxy - Would be great if this utilised the IWebProxy element of the System.net library. Any workarounds welcome... Thanks, Dan

Id #28 | Release: None | Updated: Oct 27, 2016 at 6:29 PM by webking | Created: Oct 26, 2016 at 1:44 PM by danielhitch

Generic error thrown while direct input any github api url

Generic error thrown while direct input any github api url. When I try any github url I get the error, while direct input a public url or a private one with token. Exemple url: https://api.git...

Id #24 | Release: None | Updated: Oct 28, 2016 at 5:41 PM by Keyslegend | Created: Sep 27, 2016 at 2:00 AM by Keyslegend

JSON Source failed the pre-execute phase

Hi, I have a strange error when Executing the task. Error is below [SSIS.Pipeline] Error: JSON Source Statistics failed the pre-execute phase and returned error code 0x80131500.

Id #23 | Release: None | Updated: Nov 7, 2016 at 12:50 AM by webking | Created: Sep 19, 2016 at 10:23 PM by olenibor

How to provide basic authorisation to a rest API

I am trying to connect to a HTTPS restfull webservice and need to provide basic authentication but I cannot seem to provide this to the component. Does this support this function? Many thanks Lee

Id #22 | Release: Version 1.1.000 with SQL2016 support | Updated: Mon at 11:01 PM by webking | Created: Aug 27, 2016 at 12:13 PM by LeeConnor

Error when loading JSON File as Array.

I'm getting the following error in SSIS when trying to load a JSON file, that contains an array of my data. [JSON Source Component] Error: One or more errors occurred. at System.Threading.Task...

Id #21 | Release: None | Updated: Sep 2, 2016 at 9:36 AM by invicta0 | Created: Aug 23, 2016 at 10:51 PM by michaelteff