New Features/Improvements NEW: Dynamics CRM Destination – Allow to update OwnerID field in older CRM version (i.e. lower than v9) NEW: Dynamics CRM Destination – Use mapped type field in Update / Upsert operation to set EntityReference fields (e.g. ownerid ) – Right now system picks first type from Allowed LinkedEntity list (see Advanced Custom Properties) NEW: General […]
Introduction ODBC PowerPack v1.2 release brought an interesting feature for all API drivers. New version gives you an ability to create Custom Objects. You can create parameterized Stored Procedure and Virtual Tables on the same Data Source (ODBC DSN or Data Gateway Data Source). For more information you see here Custom Objects There are mainly […]
Introduction In our previous post, we discovered how to read and write MongoDB data using ZappySys MongoDB Source and Destination SSIS connectors. However, it was all about connecting to the on-premises hosted version of MongoDB. In this post, we will focus on connecting specifically to the Replica Set Cluster in MongoDB Atlas (a cloud database service by MongoDB). After […]
New Features/Improvements NEW: All API Drivers – Add Custom Stored Procedure support (With Compiled Metadata support for faster performance) NEW: All API Drivers – Add support for count(*) NEW: All API Drivers – Add support for multi statements NEW: All API Drivers – Add Support for Placeholder functions in HTTP Dynamic Token Request (i.e . Headers/Body/URL) NEW: All API Drivers […]
New Features/Improvements NEW: Amazon Storage Task, Azure Storage Task, Secure FTP Storage Task, Advanced File System Task – Add option to get latest /oldest file path from specified folder or pattern search NEW: General – Add Placeholder Function FUN_TIMESTAMP_UNIX to return Unix Style Timestamp of current UTC DateTime (i.e. epoch) (Usage 1325394000 or 1587560359 for Current time) […]
Introduction In this article, we will show how to work with the Web API Destination and create a dynamic URL, Body or header. For this purpose, we will use the following components: ZappySys SSIS PowerPack component to make things work: In these examples, we are going to show different examples of how to send a dynamic URL, dynamic […]
New Features/Improvements NEW: General – Upgrade Core dlls to Framework 4.0 NEW: OAuth Connection Manager – Add Validation for Changing Refresh Token File so user doesnt save Token Backup file to RefreshToken File Path by mistake Bug fixes FIX: JSON / XML Source – When you enable Array Flattening Option – You may get error – Failed to […]
Introduction In our previous article, we saw How to Get Office 365 data in Power BI. Now let’s look at How to Get Office 365 Mail Attachments using SSIS without any coding. Microsoft Graph API is a unified way to access many Microsoft services API including Office 365 API. In this post, we will use SSIS JSON / […]
New Features/Improvements NEW: Amazon SQS Source – Add columns for SequenceNumber, MessageGroupId and MessageDeduplicationId NEW: Amazon SQS Source, Azure Queue Source – Add option MaxRetryOnNullMessage to retry for N times before stop reading from queue NEW: Dummy Data Source – Add Random GUID support for DT_GUID type NEW: General – Add option to Import / Export Columns Mapping Grid […]
How to convert SQL to CSV in SSIS There are several tricks related to convert SQL to CSV. For example, dates, working with variables, converting text, working with stored procedures. In this article, we will work with several tips to convert SQL Server data to the CSV format using CSV. For this article, we will use the following […]