{"id":7561,"date":"2019-08-02T13:03:21","date_gmt":"2019-08-02T13:03:21","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7561"},"modified":"2019-10-01T11:47:32","modified_gmt":"2019-10-01T11:47:32","slug":"read-write-azure-table-storage-data-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/","title":{"rendered":"How to Read\/Write Azure Table Storage data in SSIS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-thumbnail wp-image-7562 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source-150x150.png\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source-300x300.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png 448w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/>In our previous blog, we saw how to\u00a0read\/write <a href=\"https:\/\/zappysys.com\/blog\/read-azure-blob-storage-files-ssis-csv-json-xml\/\" target=\"_blank\" rel=\"noopener\">Azure Blob Storage Files in SSIS (CSV, JSON, XML Format files).<\/a>\u00a0Now in this blog, we will see how to Read\/Write Azure Table Storage data in SSIS.\u00a0To illustrate, we will use\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys SSIS PowerPack<\/a>, which includes several tasks to import\/export data from multiples sources to multiple destinations like flat files, Azure, AWS, databases, Office files and more. They are\u00a0Coding free, drag and drop high-performance suite of\u00a0<em>Custom SSIS Components<\/em>\u00a0and\u00a0<em>SSIS Tasks.<\/em>\u00a0If you like to perform other operations on Azure Blob Storage Files (e.g. Download, Upload, Create, Delete) then\u00a0<a href=\"https:\/\/zappysys.com\/blog\/category\/ssis\/tasks\/ssis-azure-blob-storage-task\/\" target=\"_blank\" rel=\"noopener\">check these articles<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<h2>Component Mentioned in this article<\/h2>\n<div class=\"su-table su-table-alternate\">\n<table style=\"height: 44px;width: 307px\">\n<tbody>\n<tr style=\"height: 22px\">\n<td style=\"height: 22px;width: 1px\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3074\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source.png\" alt=\"\" width=\"40\" height=\"40\" \/><\/a><\/td>\n<td style=\"height: 22px;width: 247px\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/azure-table-storage-source.htm\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Source<\/a><\/td>\n<\/tr>\n<tr style=\"height: 22px\">\n<td style=\"height: 22px;width: 1px\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-adapter.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3074\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-adapter.png\" alt=\"\" width=\"40\" height=\"40\" \/><\/a><\/td>\n<td style=\"height: 22px;width: 247px\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/azure-table-storage-destination.htm\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Destination<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2><span id=\"Prerequisite\"><span id=\"Requirements\">Prerequisite<\/span><\/span><\/h2>\n<ol>\n<li>First, you will need to have SSIS installed<\/li>\n<li>Secondly, make sure to have SSDT<\/li>\n<li>Download and install\u00a0<a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=717179&amp;clcid=0x4009\" target=\"_blank\" rel=\"noopener\">Microsoft Azure Storage Emulator<\/a><\/li>\n<li>Download and install\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/features\/storage-explorer\/\" target=\"_blank\" rel=\"noopener\">Microsoft Azure Storage Explorer<\/a><\/li>\n<li>Finally, do not forget to install\u00a0ZappySys\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">SSIS PowerPack<\/a><\/li>\n<\/ol>\n<p><strong>NOTE:<\/strong>\u00a0If you want to use Live account (Azure Blob Storage) then you can skip Step #3<\/p>\n<h2><span id=\"What_is_Azure_Blob_Storage\">What is Azure Table Storage?<\/span><\/h2>\n<p>Azure Table storage stores large amounts of structured data. The service is a NoSQL datastore which accepts authenticated calls from inside and outside the Azure cloud. Azure tables are ideal for storing structured, non-relational data. Common uses of Table storage include:<\/p>\n<div id=\"attachment_7567\" style=\"width: 310px\" class=\"wp-caption alignright\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-intro.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7567\" class=\"wp-image-7567 size-medium\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-intro-300x158.png\" alt=\"Microsoft Azure Table Storage Introduction\" width=\"300\" height=\"158\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-intro-300x158.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-intro.png 468w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-7567\" class=\"wp-caption-text\">Microsoft Azure Table Storage Introduction<\/p><\/div>\n<ul>\n<li>Storing TBs of structured data capable of serving web-scale applications<\/li>\n<li>Storing datasets that don&#8217;t require complex joins, foreign keys, or stored procedures and can be denormalized for fast access<\/li>\n<li>Quickly querying data using a clustered index<\/li>\n<li>Accessing data using the OData protocol and LINQ queries with WCF Data Service .NET Libraries<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>You can use Table storage to store and query huge sets of structured, non-relational data, and your tables will scale as demand increases.<\/p>\n<h2><span id=\"Getting_Started\">Getting Started<\/span><\/h2>\n<p>In order to start, we will show several examples. Zappysys includes an <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-table-storage-source\/\" target=\"_blank\" rel=\"noopener\">SSIS Azure Table Storage Source.<\/a>\u00a0Here we are showing you is, how to Read\/Write Azure Table Storage data in SSIS.<\/p>\n<p>You can connect to your Azure Storage Account by entering your storage account credentials. Here I am showing an example of the use of the local Azure Storage Emulator.<\/p>\n<h2><span id=\"Setup_Azure_Storage_client_tools\">Setup Azure Storage client tools and Create Table<\/span><\/h2>\n<ol>\n<li>Once you have\u00a0<a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=717179&amp;clcid=0x4009\" target=\"_blank\" rel=\"noopener\">downloaded and installed a storage emulator<\/a>\u00a0You can launch Microsoft Azure Storage Emulator from its Physical location or from the desktop or start menu shortcut.\n<div id=\"attachment_3631\" style=\"width: 869px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3631\" class=\"wp-image-3631 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location.png\" alt=\"Azure Storage Emulator Physical Location\" width=\"859\" height=\"94\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location.png 859w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location-300x33.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location-768x84.png 768w\" sizes=\"(max-width: 859px) 100vw, 859px\" \/><\/a><p id=\"caption-attachment-3631\" class=\"wp-caption-text\">Azure Storage Emulator Physical Location<\/p><\/div><\/li>\n<li>If you can see the below-attached Command Prompt screen after Emulator started. Then you can proceed to start Microsoft Azure Storage Explorer as the Azure Storage Emulator is started successfully.\n<div id=\"attachment_3633\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-screen-after-started-e1552723801433.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3633\" class=\"wp-image-3633 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-screen-after-started-e1552723801433.png\" alt=\"Command Prompt Screen after Microsoft Azure Storage Emulator Started\" width=\"700\" height=\"237\" \/><\/a><p id=\"caption-attachment-3633\" class=\"wp-caption-text\">Command Prompt Screen after Microsoft Azure Storage Emulator Started<\/p><\/div><\/li>\n<li>Now, you have to\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/features\/storage-explorer\/\" target=\"_blank\" rel=\"noopener\">download and install Microsoft Azure Storage Explorer<\/a>\u00a0and then you can launch Microsoft Azure Storage Explorer from its Physical location or from the desktop or start menu shortcut.\n<div id=\"attachment_3635\" style=\"width: 837px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3635\" class=\"wp-image-3635 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location.png\" alt=\"Microsoft Azure Storage Explorer Location\" width=\"827\" height=\"97\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location.png 827w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location-300x35.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location-768x90.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><p id=\"caption-attachment-3635\" class=\"wp-caption-text\">Microsoft Azure Storage Explorer Location.<\/p><\/div><\/li>\n<li>If you don&#8217;t have Azure Storage account then it&#8217;s easy to\u00a0<a href=\"http:\/\/azure.microsoft.com\/en-us\/pricing\/free-trial\/\" target=\"_blank\" rel=\"noopener\">get FREE Trial Azure Storage account<\/a>\u00a0or use your MSDN to get credit each month which will be more than enough for real testing. If you prefer to avoid all this hassle then Microsoft provides another great way to test Azure Storage functionality is totally offline mode on your local machine. You can just\u00a0<a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=42317\" target=\"_blank\" rel=\"noopener\">download Azure Storage Emulator<\/a>\u00a0and start testing.<\/li>\n<li>\u00a0<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/azure\/hh403989.aspx\" target=\"_blank\" rel=\"noopener\">Click here<\/a>\u00a0to learn more about how to configure Azure Storage Emulator for Testing and Development purposes. In order to connect to Azure Storage Service from SSIS, you will need Storage AccountName and an AccessKey. Ask your SysAdmin or responsible person to provide that information to you. Here are sample Account Name and Access Key(<b>this is just example key which may differ in your case<\/b>)\n<pre class=\"lang:default decode:true\">Account Name: mystorageaccount \r\nAccess Key: Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq\/K1SZFPTOtr\/KBHBeksoGMGw==<\/pre>\n<\/li>\n<li>For Creating a Tables, First of all, you need to go to Microsoft Storage Explorer Window. Then you can go through like this way (Storage Accounts \u2013&gt; Emulator &#8211; Default Ports(Key) \u2013&gt; Tables. Right-click on Tables and Select Create Table and put your table name you want.\n<div style=\"width: 360px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-create-table.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-create-table.png\" alt=\"Create Tables in Azure Table Storage Emulator\" width=\"350\" height=\"479\" \/><\/a><p class=\"wp-caption-text\">Create Tables in Azure Table Storage Emulator<\/p><\/div><\/li>\n<\/ol>\n<h2>Write data using ZS Azure Table Storage Destination<\/h2>\n<p>In this tutorial, you will learn how to write data into Azure Table Storage. You can use\u00a0<a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/dummydata-source.htm\" target=\"_blank\" rel=\"noopener\">ZS DummyData Source<\/a>\u00a0for practice it(In this case it&#8217;s from SQL Server Source). So, Let&#8217;s start with an example. In this SSIS we will write data into Azure Table Storage using ZS Azure Table Storage Destination.<\/p>\n<ol>\n<li>Once you have created Azure Storage Table and you got valid Account Name and AccessKey (for the local emulator you don&#8217;t need this) you may proceed to create a new SSIS package. In BIDS\/SSDT create new SSIS package<\/li>\n<li>From the SSIS toolbox drag and drop Data Flow Task on the control flow designer surface.\n<div id=\"attachment_7934\" style=\"width: 470px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7934\" class=\"wp-image-7934 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png\" alt=\"Drag and Drop SSIS Data Flow Task from SSIS Toolbox\" width=\"460\" height=\"155\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png 460w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task-300x101.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/a><p id=\"caption-attachment-7934\" class=\"wp-caption-text\">Drag and Drop SSIS Data Flow Task from SSIS Toolbox<\/p><\/div><\/li>\n<li>Double click on the DataFlow task to see DataFlow designer surface.<\/li>\n<li>Here, In Visual Studio, drag and drop the OLE DB Source and Azure Table Storage Destination in the design surface and join the components with the blue arrow.\n<div style=\"width: 567px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-adapter-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-adapter-drag.png\" alt=\"SSIS Azure Table Storage Destination - Drag and Drop\" width=\"557\" height=\"167\" \/><\/a><p class=\"wp-caption-text\">SSIS Azure Table Storage Destination &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Now, we need two connection, OLE DB Connection, and Azure Storage Connection. Click\u00a0<a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/azure-storage-connection-manager.htm\" target=\"_blank\" rel=\"noopener\">here<\/a>\u00a0to create Azure Storage Connection.<\/li>\n<\/ol>\n<h3>How to create OLE DB Connection<\/h3>\n<ol>\n<li>Let&#8217;s, Right-click on Connection Managers Panel to Create OLE DB Connection, so you can use Source and Context Menu will appear, Select New OLE DB Connection from the Context Menu.\n<div style=\"width: 485px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-new-oledb-connection-step-1.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-new-oledb-connection-step-1.png\" alt=\"OLE DB Connection - Create New Connection\" width=\"475\" height=\"353\" \/><\/a><p class=\"wp-caption-text\">OLE DB Connection &#8211; Create New Connection<\/p><\/div><\/li>\n<li>Now, click on New Button to create Connection.\n<div style=\"width: 665px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-new-oledb-connection-step-2.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-new-oledb-connection-step-2.png\" alt=\"OLE DB Connection - Create New Connection\" width=\"655\" height=\"558\" \/><\/a><p class=\"wp-caption-text\">OLE DB Connection &#8211; Create New Connection<\/p><\/div><\/li>\n<li>Let&#8217;s Configure Connection Manager, just Follow steps one by one as we have created.\n<div style=\"width: 730px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-new-oledb-connection-step-3.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-new-oledb-connection-step-3.png\" alt=\"OLE DB Connection - Configure Connection\" width=\"720\" height=\"625\" \/><\/a><p class=\"wp-caption-text\">OLE DB Connection &#8211; Configure Connection<\/p><\/div><\/li>\n<li>Click on the OK button to save configure Setting UI.<\/li>\n<\/ol>\n<h3>Write data into Azure Storage\u00a0Table in SSIS<\/h3>\n<ol>\n<li>Double click on OLE DB Source for configure it.<\/li>\n<li>Let&#8217;s Configure in Connection Manager, just follow the below image steps.\n<div style=\"width: 828px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-oledb-source-editor-manager.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/oledb-connection-manager\/ssis-oledb-source-editor-manager.png\" alt=\"OLE DB Source - Configure\" width=\"818\" height=\"560\" \/><\/a><p class=\"wp-caption-text\">OLE DB Source &#8211; Configure<\/p><\/div><\/li>\n<li>Click OK to Save OLE DB Source Editor UI Settings.<\/li>\n<li>Now double click Azure Table Storage Destination to configure it.<\/li>\n<li>On [Connection Manager] tab select Azure Storage Connection manager.\n<div style=\"width: 800px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-select-adapter-connection.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-select-adapter-connection.png\" alt=\"ZS Azure Table Storage Destination - Connection Manager\" width=\"790\" height=\"287\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Destination &#8211; Connection Manager<\/p><\/div><\/li>\n<li>Click on [Component Properties] tab and select AccessMode=Table and Pick destination Table from the Tables dropdown list.<br \/>\n<div class=\"su-note\"  style=\"border-color:#e5de9d;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#fff8b7;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">If you choose Reload option then target table is first truncated before inserting records so be careful with Reload option.<\/div><\/div>\n<div style=\"width: 800px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-select-table.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-select-table.png\" alt=\"ZS Azure Table Storage Destination - Component Properties\" width=\"790\" height=\"509\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Destination &#8211; Component Properties<\/p><\/div><\/li>\n<li>Click on [Mappings] tab and verify mapping. Drop CustomerID and RecordID mappings and reconnect as shown below. This is just to make sure PrimaryKey columns are mapped.\n<div style=\"width: 800px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-select-mappings.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-storage-destination-select-mappings.png\" alt=\"ZS Azure Table Storage Destination - Column Mappings\" width=\"790\" height=\"479\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Destination &#8211; Column Mappings<\/p><\/div><\/li>\n<li>Click OK to save settings.<\/li>\n<li>Execute the package and verify the target data.\n<div style=\"width: 359px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-write-data-sample.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-write-data-sample.png\" alt=\"ZS Azure Table Storage Destination - Execute the Package\" width=\"349\" height=\"317\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Destination &#8211; Execute the Package<\/p><\/div>\n<div style=\"width: 892px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-console-verify-record-count.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-destination\/ssis-azure-table-console-verify-record-count.png\" alt=\"ZS Azure Table Storage Verify Customers Table Data\" width=\"882\" height=\"413\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage &#8211; Verify Customers Table Data<\/p><\/div><\/li>\n<\/ol>\n<h2>Read data using ZS Azure Table Storage Source<\/h2>\n<p>In this tutorial, you will learn how to read data from Azure Table Storage in SSIS using the ZS Azure Table Storage Source adapter. In this SSIS we will read data with SQL Query and Table Mode. So Let&#8217;s begin it.<\/p>\n<ol>\n<li>You may proceed to create a new SSIS package. In BIDS\/SSDT create a new SSIS package.<\/li>\n<li>From the SSIS toolbox drag and drop Data Flow Task on the control flow designer surface.\n<div style=\"width: 470px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/drag-and-drop-data-flow-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/drag-and-drop-data-flow-task.png\" alt=\"SSIS Data Flow Task - Drag and Drop\" width=\"460\" height=\"155\" \/><\/a><p class=\"wp-caption-text\">SSIS Data Flow Task &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Double click on the DataFlow task to see DataFlow designer surface.<\/li>\n<li>From the SSIS toolbox drag and drop Azure Table Storage Source on the data flow designer surface.\n<div style=\"width: 538px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-drag.png\" alt=\"ZS Azure Table Storage Source - Drag and Drop\" width=\"528\" height=\"99\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Source &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Now, we need an Azure Storage connection. Click\u00a0<a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/azure-storage-connection-manager.htm\" target=\"_blank\" rel=\"noopener\">here<\/a>\u00a0to Create Connection.<\/li>\n<\/ol>\n<h3>Extract data with Query Mode<\/h3>\n<ol>\n<li>Here, we are getting data using Query Mode with Dynamic expression value.<\/li>\n<li>Lets, create a Variable with correct DataType and Value, use the following image.\n<div style=\"width: 442px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-create-variable.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-create-variable.png\" alt=\"SSIS Variables - Create Variable and Store Value\" width=\"432\" height=\"133\" \/><\/a><p class=\"wp-caption-text\">SSIS Variables &#8211; Create Variable and Store Value<\/p><\/div><\/li>\n<li>Double click Azure Table Storage Source to configure it.<\/li>\n<li>Select the connection we have created before, set AccessMode to Query. You can use the following SQL Query and select Variable. Click here for more\u00a0<a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/index.htm#page=azure-table-storage-source.htm#A_QueryLanguage\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Query Examples.<\/a>\n<pre class=\"lang:default decode:true\">SELECT * FROM Customers\r\nWHERE Country = '{{User::varCountry}}'<\/pre>\n<div style=\"width: 850px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-query-data-preview.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-query-data-preview.png\" alt=\"ZS Azure Table Storage Source - Configure Query Mode\" width=\"840\" height=\"673\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Source &#8211; Configure Query Mode<\/p><\/div><\/li>\n<li>Click on the Preview button to see Data Preview and\u00a0OK button to save configure setting UI.<\/li>\n<li>From the SSIS toolbox drag and drop Trash Destination on the data flow designer surface.\n<div style=\"width: 529px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ssis-trash-destination-adapter-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ssis-trash-destination-adapter-drag.png\" alt=\"ZS Trash Destination - Drag and Drop\" width=\"519\" height=\"121\" \/><\/a><p class=\"wp-caption-text\">ZS Trash Destination &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Now single click on the Azure Table Storage Source, once you see the blue arrow from the source &#8230; connect it to Trash Destination.<\/li>\n<li>Double click on ZS Trash Destination to Configure it.\n<div style=\"width: 622px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ui-trash-destination-settings.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ui-trash-destination-settings.png\" alt=\"ZS Trash Destination - Configure\" width=\"612\" height=\"523\" \/><\/a><p class=\"wp-caption-text\">ZS Trash Destination &#8211; Configure<\/p><\/div><\/li>\n<li>Click on the OK button to save Trash Destination configure setting UI.<\/li>\n<li>Execute the package and verify source data in the data viewer.\n<div style=\"width: 282px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-extract-data-query-mode.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-extract-data-query-mode.png\" alt=\"SSIS ZS Azure Table Storage Source - Execute the Package\" width=\"272\" height=\"314\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Azure Table Storage Source &#8211; Execute the Package<\/p><\/div><\/li>\n<\/ol>\n<h3>Extract data with Table Mode<\/h3>\n<ol>\n<li>So, Double click Azure Table Storage Source to configure it.<\/li>\n<li>In the Azure Table Storage Source, Select the connection we have created, set AccessMode to Table and Select Table from the Tables dropdown.\n<div style=\"width: 646px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-table-data-preview.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-table-data-preview.png\" alt=\"SSIS ZS Azure Table Source - Configure Table Mode\" width=\"636\" height=\"473\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Azure Table Source &#8211; Configure Table Mode<\/p><\/div><\/li>\n<li>Click on the Preview button to see Data Preview and OK button to save configure setting UI.<\/li>\n<li>From the SSIS toolbox drag and drop Trash Destination on the data flow designer surface.\n<div style=\"width: 529px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ssis-trash-destination-adapter-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ssis-trash-destination-adapter-drag.png\" alt=\"ZS Trash Destination - Drag and Drop\" width=\"519\" height=\"121\" \/><\/a><p class=\"wp-caption-text\">ZS Trash Destination &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Now single click on the Azure Table Storage Source, once you see the blue arrow from the source &#8230; connect it to Trash Destination.<\/li>\n<li>Double click on ZS Trash Destination to Configure it.\n<div style=\"width: 622px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ui-trash-destination-settings.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ui-trash-destination-settings.png\" alt=\"ZS Trash Destination - Configure\" width=\"612\" height=\"523\" \/><\/a><p class=\"wp-caption-text\">ZS Trash Destination &#8211; Configure<\/p><\/div><\/li>\n<li>Click on the OK button to save Trash Destination configure setting UI.<\/li>\n<li>In the last, Execute the package and verify source data in the data viewer.\n<div style=\"width: 283px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-extract-data-sample.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/azure-table-storage-source\/ssis-azure-table-storage-source-extract-data-sample.png\" alt=\"ZS Azure Table Storage Source - Execute the Package\" width=\"273\" height=\"310\" \/><\/a><p class=\"wp-caption-text\">ZS Azure Table Storage Source &#8211; Execute the Package<\/p><\/div><\/li>\n<\/ol>\n<h2>Conclusion<\/h2>\n<p>After all, In this blog, we learned how to write data in Azure Table Storage in SSIS. We used the Azure Table Storage Destination for write and Azure Table Storage Source to read data from Microsoft Azure Table Storage using Query and Table mode.\u00a0You can\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">download SSIS PowerPack here<\/a>\u00a0to try many other scenarios not discussed in this blog along with 70+ other components.<\/p>\n<h2><span id=\"References\">References<\/span><\/h2>\n<p>There are a few details you should use the following links for more information:<\/p>\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-table-storage-destination\/\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Destination<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-table-storage-source\/\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Source<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/blog\/category\/ssis\/components\/ssis-trash-destination\/\" target=\"_blank\" rel=\"noopener\">ZS Trash Destination<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/table-storage-overview\" target=\"_blank\" rel=\"noopener\">Microsoft Azure Table Storage<\/a><\/li>\n<li><strong>Help File:<\/strong>\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/azure-table-storage-destination.htm\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Destination<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/azure-table-storage-source.htm\" target=\"_blank\" rel=\"noopener\">Azure Table Storage Source<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/trash-destination.htm\" target=\"_blank\" rel=\"noopener\">ZS Trash Destination<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In our previous blog, we saw how to\u00a0read\/write Azure Blob Storage Files in SSIS (CSV, JSON, XML Format files).\u00a0Now in this blog, we will see how to Read\/Write Azure Table Storage data in SSIS.\u00a0To illustrate, we will use\u00a0ZappySys SSIS PowerPack, which includes several tasks to import\/export data from multiples sources to multiple destinations like [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7562,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540,539],"tags":[183,533,128,509,531,6,313,314,532,305,12,478,528,529,7],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Read\/Write Azure Table Storage data in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to Read\/Write Azure Table Storage data in SSIS using ZappySys PowerPack components Azure Table Storage Source and Destination.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Read\/Write Azure Table Storage data in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to Read\/Write Azure Table Storage data in SSIS using ZappySys PowerPack components Azure Table Storage Source and Destination.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-08-02T13:03:21+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-10-01T11:47:32+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"448\" \/>\r\n\t<meta property=\"og:image:height\" content=\"448\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/\",\"name\":\"How to Read\/Write Azure Table Storage data in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png\",\"datePublished\":\"2019-08-02T13:03:21+00:00\",\"dateModified\":\"2019-10-01T11:47:32+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"How to Read\/Write Azure Table Storage data in SSIS using ZappySys PowerPack components Azure Table Storage Source and Destination.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png\",\"width\":448,\"height\":448},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Read\/Write Azure Table Storage data in SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Read\/Write Azure Table Storage data in SSIS | ZappySys Blog","description":"How to Read\/Write Azure Table Storage data in SSIS using ZappySys PowerPack components Azure Table Storage Source and Destination.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to Read\/Write Azure Table Storage data in SSIS | ZappySys Blog","og_description":"How to Read\/Write Azure Table Storage data in SSIS using ZappySys PowerPack components Azure Table Storage Source and Destination.","og_url":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2019-08-02T13:03:21+00:00","article_modified_time":"2019-10-01T11:47:32+00:00","og_image":[{"width":448,"height":448,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/","url":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/","name":"How to Read\/Write Azure Table Storage data in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png","datePublished":"2019-08-02T13:03:21+00:00","dateModified":"2019-10-01T11:47:32+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"How to Read\/Write Azure Table Storage data in SSIS using ZappySys PowerPack components Azure Table Storage Source and Destination.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-azure-table-storage-source.png","width":448,"height":448},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/read-write-azure-table-storage-data-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Read\/Write Azure Table Storage data in SSIS"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7561"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=7561"}],"version-history":[{"count":34,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7561\/revisions"}],"predecessor-version":[{"id":8088,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7561\/revisions\/8088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/7562"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=7561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=7561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=7561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}