SharePoint Document Library supports version histories, so you can store and track different versions of each document file within the library as changes are made to the file. Such version control infrastructure provides many unique benefits. For instance, if something went wrong with one of the files because of a recent accidental/unintended change, you can easily restore it to a prior version as needed. Also, in your ETL development, you might often run into the requirements that you need to extract all previous versions of a file. In this blog post, we will show how to achieve this using our SharePoint Source component to download document library file versions and using the Premium File System Destination component (offered in SSIS Productivity Pack) to save them to a local file system in SSIS.

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.

HubSpot has announced some recent security enhancements in their APIs which now provide more granular CRM scopes. With this change, you will need to update your HubSpot connections in order to stay compliant.

There are cases where we would need to retrieve a set of files from a storage location, which are dropped on the same day, and read them one by one, to then store them into a database table. We can easily achieve this using KingswaySoft components and the SSIS Foreach loop container.

Custom fields have some special behaviors in the QuickBooks desktop application, which makes them to some degree difficult to work with if we don't know exactly how to work with them. This can create some substantial challenges for any integration projects that you might be working on. In this blog post, we will explain how to work with custom fields using our SSIS Integration Toolkit for QuickBooks by giving you some detailed instructions which we hope you may leverage in your integration projects.

The Snowflake command task that is a control flow level task can be used to easily execute functions in Snowflake and use it for further data flow executions.

It is a very common business requirement that in our job we may receive documents in some particular formats, which the business team would like to have them converted into PDF files. Such requirements arise from many of the advantages when using PDF formats for file exchanges, such as portability, universal compatibility, reliability, security, size reduction, versatility, professionalism, etc. Given such common requirement, it would be highly useful to have a tool that can pick up documents from a specific location and have them converted to a PDF files in an automated manner, such as an automated ETL process. In this blog post, we will show you how to easily achieve this using components from our SSIS Productivity Pack product offering.

In our ETL development, we don't always receive the data in the exact format that we expect it to be. For instance, there might be cases that the incoming data is a string value while we expect an integer, or in some other cases, there might be unexpected whitespaces which can make the lookup difficult. This blog post will specifically cover the lookup scenario and show you how to achieve the lookup functionality without additional extra work.