Introduction If you have need to integrate REST API in SSIS (i.e. fetch JSON, XML, CSV via HTTP call) and wondering how to Read API data in SSIS and Load into SQL DB (i.e. SQL Server, MySQL, Oracle) then you are at the right place. In this article we will cover simple step by step […]
Monthly Archives: September 2020
ODBC PowerPack 1.3.0 released
Version 1.3.0.10909 [Sep 16, 2020] This version brings brand new JDBC Bridge driver which can connect data using any JDBC Driver in ODBC Apps (e.g. Excel). Many vendors dont provide ODBC Driver because its expensive and complex to build so they simply supply you Java based JDBC Driver, however these JDBC drivers work only with […]
SSIS PowerPack 3.1.4 released
New Features/Improvements NEW: Dynamics CRM Destination – Add Support for Multiple Threads for faster performance (Added EnableParallelThreads, MaxParallelThreads Properties) NEW: General – Add new functions LOWER, UPPER, FUN_UNIX_TIMESTAMP_TO_DATE (When input is Seconds format) and FUN_UNIX_TIMESTAMP_MS_TO_DATE (When input is Milliseconds format) NEW: General – Add product Update notification (Show release notes when new available) NEW: General – Enforce License manager […]