Periodically Clean Up File Folders Using SSIS Productivity Pack

29 May 2023
KingswaySoft Team

Applications and processes create local caches in the hard drive folder that require periodic cleanups. The Team foundation Server builds the cache on the client machine, which in the long run may create space or volume issues in the machine. A purge of these caches would be needed in this scenario. However, deleting recent caches as soon as it builds may not be a good idea too. Therefore, periodic deletion of historic caches could be a feasible approach. We will show you how this can be achieved using KingswaySoft.


Preserving Sensitive Properties in SSIS Packages

19 December 2022
KingswaySoft Team

In SSIS, the sensitive credentials have to be handled in a special way to ensure that they get preserved and decrypted while the packages run in an unattended way. There are a few means to do this, and in this blog post, we will discuss some popular ways this can be done.


Working with NetSuite Custom Fields using KingswaySoft SSIS Components

31 May 2022
KingswaySoft Team

NetSuite Custom fields are fields that you can add to records and transactions which can be used to save some additional information. This provides quite some flexibility when working with the NetSuite application if we have some special business requirements which cannot be accomplished using those out-of-box fields. Once added, those fields require some special attention in order to use use them in SSIS ETL data flows. In this blog post, we will show you how this can be done easily by using KingswaySoft components.


Construct ActivityParty JSON Values for Dataverse Activity Entity Migration

30 March 2022
KingswaySoft Team

In this blog post, we will show a simple solution that can be used to generate the JSON structure from database tables which can be sent to CDS/CRM destination components for writing, we demonstrate the use of SQL FOR JSON clause to achieve the purpose.


Check File Existence in SSIS with Ease

26 July 2021
KingswaySoft Team

This post will demonstrate how to perform file existence check in SSIS without writing a single line of code by using KingswaySoft Premium File Properties Task.


Performing File Upload Using HTTP Multipart Requests in SSIS

19 February 2021
KingswaySoft Team

In this blog post, we will discuss how to perform file upload using HTTP multipart/form-data format in SSIS without having to write a single line of code.


Parsing Advanced JSON Structures with Ease Using SSIS Productivity Pack

16 February 2021
KingswaySoft Team

In this blog post, we will be going through some complex JSON document structures and demonstrate how to configure KingswaySoft JSON Source/Extract component to extract data from those JSON documents efficiently.


Paging REST requests in SSIS using KingswaySoft JSON Source Component

14 January 2021
Chen Huang

In this blog post, we will be going through some of the most common API pagination methods and demonstrate how to configure KingswaySoft JSON Source component to send out the paginated requests in SSIS.


Archive

Tags