I am an experienced SSIS-developer, but brand new to Kingswaysoft Json Source Editor (and all other Kingswaysoft SSIS-stuff!) I have several hundreds API sources which are build very similar: { "values": { "XXX": { "a": { "2000": -0.26, "2001": -0.146,…
I need help to construct a TSQL query (SQL Server 2016) that can produce the following JSON structure. The structure is as follows.The root is called "Agreement". Each agreement got the main attributes AgreementDate, Position, OrganizationName. It is then followed…
I recently installed Visual Studio 2022 and SSMS 19.1. I am trying to open a SSIS package that I previously had opened and saved in Visual Studio 2012 via Visual Studio Solution Explorer in a New Solution that I created.…
I have the below code which I am using to send JSON data to an API using HTTPClient. I want to log the HTTP response/status code such as 200, 201, 400 etc. Please can someone assist me with how to…
so I ran my SSIS Job on my local machine with no errors and deployed it to SQL Agent 2019 and I'm using Visual Studio 2019 and the TargetVersion is set to SQL Server 2019 and I'm getting the followings…
I've setup a Cost Management export that is trigged weekly to a Storage Account. In that storage account the CSV is exported inside a container, a folder, another folder, and then inside a folder with FROM-TO dates: I would like…
I am copying data from ADLS csv file to Azure SQL DB. File contains 9 columns and mapping is done according to that, but sometimes the source file is only having 6 or 7 columns. In that case the pipeline…
We've been recently trying to migrate out of SQL Server 2016 to SQL Server 2019 on our servers, that includes upgrading all the SSIS Packages we have on our catalog. The migration wizard had no issues and migrated all packages…
I am looking for the different ways how within SSIS APIs can be called (e.g. getting data from a JSON file) or by calling APIs objects in SSIS can be accessed or configured (e.g. triggering an SSIS package). Since I'm…
I I prepared a simple c# script that can rename a file on my local directory. When I run it in visual studio it completes successfully and rename the file. the code below; public void Main() { // TODO: Add…