{"id":11893,"date":"2026-03-27T11:41:30","date_gmt":"2026-03-27T11:41:30","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=11893"},"modified":"2026-04-02T19:28:01","modified_gmt":"2026-04-02T19:28:01","slug":"ssis-tutorial-how-to-connect-blogger-with-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/","title":{"rendered":"SSIS tutorial: How to connect Blogger with SSIS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p class=\"intro-text\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-11901 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo-150x150.png\" alt=\"Blogger Logo\" width=\"134\" height=\"134\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo-300x300.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png 512w\" sizes=\"(max-width: 134px) 100vw, 134px\" \/><\/a>This tutorial walks you through the process of extracting blog posts and comments data from Blogger using the REST API and Zappysys SSIS connectors. In this guide, you will learn how to authenticate with the Blogger REST API, configure a Zappysys REST data source, and load extracted data into SQL Server. This approach eliminates the need for custom code and provides a graphical interface for managing complex API integrations.<\/p>\n<p class=\"intro-text\">Zappysys provides a powerful REST connector that simplifies integrating cloud-based APIs into your SQL Server Integration Services packages. We will demonstrate a practical ETL pattern using ZappySys REST connectivity to extract data from Blogger and load it into SQL Server within SSIS.<\/p>\n<p><!-- Prerequisites --><\/p>\n<h2>Prerequisites<\/h2>\n<p>Before you begin, make sure you have the following:<\/p>\n<ul>\n<li>First, you will need to have SSIS installed<\/li>\n<li>Secondly, make sure to have SSDT<\/li>\n<li>Thirdly, access to a Blogger blog with appropriate permissions to read public posts and comments.<\/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<\/ul>\n<p><!-- Step-by-Step Guide --><\/p>\n<h2>Steps<\/h2>\n<h3>Create\/Select a Project in the Google API Console<\/h3>\n<ol>\n<li>Navigate to the <a href=\"https:\/\/console.developers.google.com\/\">Google API Console<\/a>.<\/li>\n<li>Click on the Project Dropdown at the top bar and either select an existing project or create a new one by clicking <strong>CREATE PROJECT<\/strong>.\n<div id=\"attachment_11905\" style=\"width: 807px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-or-select-project.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11905\" class=\"wp-image-11905 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-or-select-project.png\" alt=\"\" width=\"797\" height=\"255\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-or-select-project.png 797w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-or-select-project-300x96.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-or-select-project-768x246.png 768w\" sizes=\"(max-width: 797px) 100vw, 797px\" \/><\/a><p id=\"caption-attachment-11905\" class=\"wp-caption-text\">Google Console &#8211; Create or select a project<\/p><\/div><\/li>\n<li>Once the project is set, click <strong>ENABLE APIS AND SERVICES<\/strong>.<\/li>\n<li>Search for the <strong>Blogger API v3<\/strong> and click <strong>ENABLE<\/strong>.\n<div id=\"attachment_11903\" style=\"width: 690px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Enable-Blogger-API.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11903\" class=\"wp-image-11903 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Enable-Blogger-API.png\" alt=\"\" width=\"680\" height=\"265\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Enable-Blogger-API.png 680w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Enable-Blogger-API-300x117.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><p id=\"caption-attachment-11903\" class=\"wp-caption-text\">Google Console &#8211; Enable Blogger API<\/p><\/div><\/li>\n<li>Return to the main screen and click on the <strong>OAuth Consent Screen<\/strong> tab.<\/li>\n<li>Select the <strong>External<\/strong> user type and click <strong>CREATE<\/strong>.<\/li>\n<li>Provide the application name, user support email, and developer contact information, then click <strong>SAVE AND CONTINUE<\/strong>.<\/li>\n<li>Click through the remaining scopes and summary pages (no additional scopes are required for this tutorial), and click <strong>SAVE AND CONTINUE<\/strong> on each.<\/li>\n<li>Move to the <strong>Credentials<\/strong> tab.<\/li>\n<li>Click <strong>CREATE CREDENTIALS<\/strong> in the top bar, choose <strong>OAuth Client ID<\/strong>, select <strong>Desktop App<\/strong> as the Application Type, and click <strong>Create<\/strong> to obtain your Client ID and Secret.\n<div id=\"attachment_11904\" style=\"width: 910px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-credentials.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11904\" class=\"wp-image-11904 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-credentials.png\" alt=\"\" width=\"900\" height=\"335\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-credentials.png 900w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-credentials-300x112.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Google-Console-Create-credentials-768x286.png 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/a><p id=\"caption-attachment-11904\" class=\"wp-caption-text\">Google Console &#8211; Create credentials<\/p><\/div><\/li>\n<li>Download the credentials JSON file and save it in a secure location on your development machine.<\/li>\n<\/ol>\n<h3>Create the OAuth connection for Blogger<\/h3>\n<ol>\n<li>Create or select your SSIS project, and open the package.dtsx file.<\/li>\n<li>Drag and drop the ZS REST API task from the Toolbox.<\/li>\n<li>Inside<strong> Connection Manager<\/strong>, right-click and select <strong>New connection&#8230;<\/strong><\/li>\n<li>Inside the SSIS connectors, select the <strong><strong>ZS-OAuth<br \/>\n<\/strong><\/strong><\/p>\n<div id=\"attachment_11825\" style=\"width: 959px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11825\" class=\"size-full wp-image-11825\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png\" alt=\"\" width=\"949\" height=\"447\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager.png 949w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-300x141.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2020\/02\/Create-a-new-SSIS-OAuth-API-Connection-Manager-768x362.png 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/a><p id=\"caption-attachment-11825\" class=\"wp-caption-text\">Create a new SSIS OAuth API Connection Manager<\/p><\/div><\/li>\n<li>Select the <strong>Google API provider<\/strong><\/li>\n<li>Enter the <strong>Client<\/strong> ID and <strong>Client Secret<\/strong> you generated in the past step<\/li>\n<li>Use Blogger URL scope: <code>https:\/\/www.googleapis.com\/auth\/blogger<\/code><\/li>\n<li>Generate the token<\/li>\n<li>Test the connection to ensure it is working correctly.<\/li>\n<li>Click OK to save the connection.\n<div id=\"attachment_11907\" style=\"width: 713px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/OAuth-connection-Blogger-API.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11907\" class=\"size-full wp-image-11907\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/OAuth-connection-Blogger-API.png\" alt=\"\" width=\"703\" height=\"698\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/OAuth-connection-Blogger-API.png 703w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/OAuth-connection-Blogger-API-300x298.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/OAuth-connection-Blogger-API-150x150.png 150w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><p id=\"caption-attachment-11907\" class=\"wp-caption-text\">OAuth connection &#8211; Blogger API<\/p><\/div><\/li>\n<\/ol>\n<h3>Get information from a Blog<\/h3>\n<ol>\n<li>Create a string variable <code>{{User::BlogID}}<\/code> and enter the ID from the blog you want to get information from.<\/li>\n<li>From the SSIS Toolbox, drag the<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\"><strong> ZS REST API Task<\/strong><\/a> onto the Control Flow designer.<\/li>\n<li>Double-click the task to open the editor.<\/li>\n<li>Select the connection manager you created in the previous step.<\/li>\n<li>In the URL Path field, enter: <code>https:\/\/www.googleapis.com\/blogger\/v3\/blogs\/{{User::BlogID}}\/posts<\/code><\/li>\n<li>Set the HTTP method to <strong>GET<\/strong>.<\/li>\n<li>Click the Preview tab to test the API connection and view sample data.<\/li>\n<li>If the preview is successful, click OK to configure the task.\n<div id=\"attachment_11908\" style=\"width: 917px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/REST-API-task-Blogger-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11908\" class=\"size-full wp-image-11908\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/REST-API-task-Blogger-example.png\" alt=\"\" width=\"907\" height=\"729\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/REST-API-task-Blogger-example.png 907w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/REST-API-task-Blogger-example-300x241.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/REST-API-task-Blogger-example-768x617.png 768w\" sizes=\"(max-width: 907px) 100vw, 907px\" \/><\/a><p id=\"caption-attachment-11908\" class=\"wp-caption-text\">REST API task &#8211; Blogger example<\/p><\/div><\/li>\n<\/ol>\n<h3>Save the information in a SQL table<\/h3>\n<ol>\n<li>Drag and drop a Data Flow into the Control Flow and double-click it.\n<div id=\"attachment_11784\" style=\"width: 485px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11784\" class=\"size-full wp-image-11784\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\" alt=\"\" width=\"475\" height=\"178\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png 475w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow-300x112.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/a><p id=\"caption-attachment-11784\" class=\"wp-caption-text\">Drag and drop Data flow.<\/p><\/div><\/li>\n<li>In the Data Flow, drag and drop the\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-json-file-source\/\" target=\"_blank\" rel=\"noopener\"><strong>JSON source,<\/strong><\/a> then\u00a0double-click it to configure it.\n<div id=\"attachment_11533\" style=\"width: 553px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11533\" class=\"size-full wp-image-11533\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\" alt=\"\" width=\"543\" height=\"146\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png 543w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag-300x81.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><p id=\"caption-attachment-11533\" class=\"wp-caption-text\">SSIS JSON Source &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Use the same configuration as in the REST API task, but first enable the\u00a0<strong>Use credentials <\/strong>option.<\/li>\n<li>Enter the <strong>URL<\/strong>, select the <strong>OAuth<\/strong> connection, and use the Method <strong>GET<\/strong>.<\/li>\n<li>You can use the filter option to get the object you want to get data from: <code>$.Items[*]<\/code><\/li>\n<li>Preview the data and click <strong>OK<\/strong> to save the configuration.\n<div id=\"attachment_11911\" style=\"width: 837px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/JSON-Source-Blogger-Example-Request.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11911\" class=\"size-full wp-image-11911\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/JSON-Source-Blogger-Example-Request.png\" alt=\"\" width=\"827\" height=\"725\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/JSON-Source-Blogger-Example-Request.png 827w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/JSON-Source-Blogger-Example-Request-300x263.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/JSON-Source-Blogger-Example-Request-768x673.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><p id=\"caption-attachment-11911\" class=\"wp-caption-text\">JSON Source &#8211; Blogger Example Request<\/p><\/div>\n<div class=\"mceTemp\"><\/div>\n<\/li>\n<li>Now drag and drop a destination component. In our case, we will use the Upsert destination component.\n<div id=\"attachment_9644\" style=\"width: 837px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/ssis-data-flow-drag-drop-upsert-destination.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-9644\" class=\"size-full wp-image-9644\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/ssis-data-flow-drag-drop-upsert-destination.png\" alt=\"SSIS - Data Flow - Drag and Drop Upsert Destination Component\" width=\"827\" height=\"385\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/ssis-data-flow-drag-drop-upsert-destination.png 827w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/ssis-data-flow-drag-drop-upsert-destination-300x140.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/08\/ssis-data-flow-drag-drop-upsert-destination-768x358.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><p id=\"caption-attachment-9644\" class=\"wp-caption-text\">SSIS &#8211; Data Flow &#8211; Drag and Drop Upsert Destination Component<\/p><\/div><\/li>\n<li>Double-click in the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-upsert-destination\/\">Upsert destination<\/a> component to configure it.<\/li>\n<li>Select the Action you want to use.<\/li>\n<li>Create or select a database connector.<\/li>\n<li>Create or select a table.<\/li>\n<li>Use the options <strong>Insert<\/strong> or\/and <strong>Update.<\/strong><\/li>\n<li>Map the column; if the columns have the same name, it will be automatic.<\/li>\n<li>Select at least one column for a <strong>primary key<\/strong>.<\/li>\n<li>Click <strong>OK<\/strong> to save the configuration.\n<div id=\"attachment_11912\" style=\"width: 968px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11912\" class=\"size-full wp-image-11912\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png\" alt=\"\" width=\"958\" height=\"645\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example.png 958w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-300x202.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-768x517.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Upsert-destination-Blogger-example-272x182.png 272w\" sizes=\"(max-width: 958px) 100vw, 958px\" \/><\/a><p id=\"caption-attachment-11912\" class=\"wp-caption-text\">Upsert destination &#8211; Blogger example<\/p><\/div><\/li>\n<li>Run the package, and you will see the data from Blogger in your database\n<div id=\"attachment_11930\" style=\"width: 350px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Blogger-result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11930\" class=\"size-full wp-image-11930\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Blogger-result.png\" alt=\"\" width=\"340\" height=\"207\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Blogger-result.png 340w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/Blogger-result-300x183.png 300w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/><\/a><p id=\"caption-attachment-11930\" class=\"wp-caption-text\">Blogger &#8211; result<\/p><\/div><\/li>\n<\/ol>\n<p><!-- Code Examples --><\/p>\n<h2>Code Examples<\/h2>\n<h3>Sample REST API Request<\/h3>\n<p>Here&#8217;s an example of retrieving blog posts using the Blogger REST API:<\/p>\n<pre><code class=\"language-http\">GET https:\/\/www.googleapis.com\/blogger\/v3\/blogs\/{blogId}\/posts\r\nAuthorization: Bearer {access_token}\r\nContent-Type: application\/json<\/code><\/pre>\n<p>Example response:<\/p>\n<pre><code class=\"language-json\">{\r\n  \"kind\": \"blogger#posts\",\r\n  \"items\": [\r\n    {\r\n      \"kind\": \"blogger#post\",\r\n      \"id\": \"7109703471293209437\",\r\n      \"title\": \"Getting started with Blogger API\",\r\n      \"content\": \"Learn how to integrate Blogger with your applications...\",\r\n      \"published\": \"2026-03-15T10:30:00Z\",\r\n      \"updated\": \"2026-03-20T14:15:00Z\",\r\n      \"url\": \"http:\/\/example.blogspot.com\/2026\/03\/getting-started.html\",\r\n      \"author\": {\r\n        \"displayName\": \"John Doe\"\r\n      }\r\n    }\r\n  ]\r\n}<\/code><\/pre>\n<h3>SQL Table Structure<\/h3>\n<p>Recommended table structure for storing Blogger posts data:<\/p>\n<pre><code class=\"language-sql\">CREATE TABLE BloggerPosts (\r\n    PostID BIGINT PRIMARY KEY,\r\n    BlogID BIGINT NOT NULL,\r\n    Title NVARCHAR(MAX),\r\n    Content NVARCHAR(MAX),\r\n    AuthorName NVARCHAR(255),\r\n    PublishedDate DATETIME,\r\n    UpdatedDate DATETIME,\r\n    PostURL NVARCHAR(MAX),\r\n    CreatedDate DATETIME DEFAULT GETDATE(),\r\n    ModifiedDate DATETIME DEFAULT GETDATE()\r\n);<\/code><\/pre>\n<p><!-- Conclusion --><\/p>\n<h2>Conclusion<\/h2>\n<p class=\"intro-text\">You have successfully learned how to use Zappysys SSIS connectors to extract data from the Blogger<br \/>\nplatform using the REST API. With ZappySys SSIS PowerPack, connecting Blogger to your SQL Server becomes<br \/>\nstraightforward and reliable. By configuring the REST connector for Blogger and using the native SSIS destination,<br \/>\nyou can build a robust ETL pipeline for extracting blog data.<\/p>\n<p class=\"intro-text\">Explore the full capabilities of the <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">ZappySys SSIS PowerPack<\/a> to optimize your data integration<br \/>\ntasks. By applying this pattern, you can extend your solution to include additional transformations, data<br \/>\nvalidation, error handling, and scheduling through SQL Server Agent.<\/p>\n<p><!-- References --><\/p>\n<p><!-- Need Help --><\/p>\n<h2>Need Help?<\/h2>\n<p class=\"section-intro\">If you encounter any issues, our support team is here to help:<\/p>\n<ol>\n<li><strong>Live Chat<\/strong> \u2014 Use the chat widget (bottom-right corner of this page)<\/li>\n<li><strong>Email<\/strong> \u2014 support@zappysys.com<\/li>\n<li><strong>Support Center<\/strong> \u2014 Visit the ZappySys Support Portal<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Introduction This tutorial walks you through the process of extracting blog posts and comments data from Blogger using the REST API and Zappysys SSIS connectors. In this guide, you will learn how to authenticate with the Blogger REST API, configure a Zappysys REST data source, and load extracted data into SQL Server. This approach eliminates [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":11901,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,8,10,444],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS tutorial: How to connect Blogger with SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to connect Blogger with SSIS - ZappySys Blog\" \/>\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\/ssis-tutorial-how-to-connect-blogger-with-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=\"SSIS tutorial: How to connect Blogger with SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to connect Blogger with SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-03-27T11:41:30+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-04-02T19:28:01+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"512\" \/>\r\n\t<meta property=\"og:image:height\" content=\"512\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/\",\"name\":\"SSIS tutorial: How to connect Blogger with SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png\",\"datePublished\":\"2026-03-27T11:41:30+00:00\",\"dateModified\":\"2026-04-02T19:28:01+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to connect Blogger with SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png\",\"width\":512,\"height\":512,\"caption\":\"Blogger Logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to connect Blogger with 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\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS tutorial: How to connect Blogger with SSIS | ZappySys Blog","description":"SSIS tutorial: How to connect Blogger with SSIS - ZappySys Blog","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\/ssis-tutorial-how-to-connect-blogger-with-ssis\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to connect Blogger with SSIS | ZappySys Blog","og_description":"SSIS tutorial: How to connect Blogger with SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/","og_site_name":"ZappySys Blog","article_published_time":"2026-03-27T11:41:30+00:00","article_modified_time":"2026-04-02T19:28:01+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/","name":"SSIS tutorial: How to connect Blogger with SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png","datePublished":"2026-03-27T11:41:30+00:00","dateModified":"2026-04-02T19:28:01+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to connect Blogger with SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/03\/logo.png","width":512,"height":512,"caption":"Blogger Logo"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-connect-blogger-with-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to connect Blogger with 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\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11893"}],"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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=11893"}],"version-history":[{"count":19,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11893\/revisions"}],"predecessor-version":[{"id":11936,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11893\/revisions\/11936"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11901"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}