{"id":12162,"date":"2026-05-29T01:54:21","date_gmt":"2026-05-29T01:54:21","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12162"},"modified":"2026-06-18T22:19:55","modified_gmt":"2026-06-18T22:19:55","slug":"ssis-tutorial-how-to-get-data-from-table-in-notion","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/","title":{"rendered":"SSIS tutorial: How to get data from table in Notion"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>Notion is a popular workspace platform used by teams to manage projects, documentation, tasks, and databases in one place. Many organisations store operational data in Notion and need to migrate it to SQL Server for reporting, analytics, and business intelligence.<\/p>\n

Using Zappysys SSIS PowerPack, you can connect SSIS to Notion REST APIs and extract pages, database records, users, and other objects without writing custom code. This tutorial demonstrates how to connect SSIS to Notion and load data into SQL Server tables using the ZappySys REST API Source.<\/p>\n

<\/h3>\n

Prerequisites<\/h2>\n
    \n
  1. SQL Server Integration Services (SSIS) is installed.<\/li>\n
  2. Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
  3. A Notion workspace with at least one database and records.<\/li>\n
  4. Zappysys SSIS PowerPack<\/a> is installed on your system.<\/li>\n<\/ol>\n

    Steps<\/h2>\n

    Create a Notion Integration and Token<\/h3>\n
      \n
    1. Go to Notion Integrations<\/a> and sign in.<\/li>\n
    2. Click New integration<\/strong>.<\/li>\n
    3. Enter a name for your integration and select the target workspace.<\/li>\n
    4. Click Create connection<\/b> to proceed.\n
    5. Configure the capabilities<\/strong> you need by checking or unchecking the relevant options.<\/li>\n
    6. Copy the generated Access Token<\/strong> and store it securely.\n
    7. If you have difficulty creating a new connection, try using the Personal Access Token <\/strong>tab.<\/li>\n<\/ol>\n

      Connect your Notion database with your new connection<\/h3>\n
        \n
      1. Open your target Notion database page in the browser.<\/li>\n
      2. Click …<\/strong> in the top-right corner.<\/li>\n
      3. Click Connections<\/strong>, search for your connection, and select it.<\/li>\n
      4. Confirm access to the connection.<\/li>\n
      5. Copy the database ID from the URL. For example:<\/li>\n
      6. Set URL<\/strong> to:\n
        https:\/\/app.notion.com\/p\/<<DATABASE_ID>>?v=..........<\/pre>\n
        \"\"<\/a>
        Notion – Set a connection to your table<\/p><\/div><\/li>\n<\/ol>\n
        Create an HTTP connection in SSIS<\/h3>\n
          \n
        1. Create or open your SSIS project and package.<\/li>\n
        2. In Connection Managers<\/strong>, right-click and choose New Connection…<\/strong><\/li>\n
        3. Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
        4. Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
        5. Paste your Notion Access token<\/strong> in the token value field.<\/li>\n
        6. Click OK<\/strong> to save the configuration.\n
          \"\"<\/a>
          Notion – Connection configuration<\/p><\/div><\/li>\n<\/ol>\n
          Create and Configure REST API Source<\/h3>\n
            \n
          1. Add a Data Flow Task<\/strong> to the Control Flow and double-click to open it.\n
          2. In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
          3. Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
          4. Select the Notion HTTP connection you created earlier.<\/li>\n
          5. Set URL<\/strong> to:\n
            https:\/\/api.notion.com\/v1\/databases\/{{User::DatabaseId}}\/query<\/pre>\n<\/li>\n
          6. Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
          7. Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
          8. Under headers, add: Notion-Version: {NotionVersion}. (Example: 2022-06-28)<\/li>\n
          9. Set JSON Path Filter<\/strong> to extract the object array. Example: $.results[*]<\/li>\n
          10. Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong> to save the configuration.\n
            \"\"<\/a>
            Notion – JSON source configuration<\/p><\/div>\n
            <\/div>\n<\/li>\n<\/ol>\n
            Configure Destination Component<\/h3>\n
              \n
            1. Add an\u00a0Upsert destination<\/strong><\/a>\u00a0(or another destination of your choice, such as\u00a0a Trash destination\u00a0<\/strong>or a\u00a0JSON\/CSV\/XML destination<\/strong>).<\/li>\n
            2. Connect the output arrow from JSON Source to the destination component.<\/li>\n
            3. Configure your SQL Server connection and target table.<\/li>\n
            4. Check the options you want to use: Insert<\/strong> or\/and Update<\/strong><\/li>\n
            5. Map the source columns to destination columns in the Mappings<\/strong> section.\n
            6. Click OK<\/strong> and execute the package.<\/li>\n
            7. Validate that Notion rows have been loaded into your SQL Server table.\n
              \"\"<\/a>
              Notion – Upsert Destination example<\/p><\/div><\/li>\n<\/ol>\n
              Conclusion<\/h2>\n
              Connecting SSIS to Notion using Zappysys REST API Source enables reliable extraction of workspace data into SQL Server for reporting and analytics. With proper token setup, database sharing, and JSON mapping, you can operationalize Notion data pipelines without custom .NET code.<\/p>\n
              Explore the full capabilities of the ZappySys SSIS PowerPack<\/a> to optimize your data integration tasks. By applying this pattern, you can extend your solution to include additional transformations, data validation, error handling, and scheduling through SQL Server Agent.<\/p>\n
              Need Help?<\/h2>\n
              If you encounter any issues, our support team is here to help:<\/p>\n
                \n
              1. Live Chat<\/strong> \u2014 Use the chat widget (bottom-right corner of this page)<\/li>\n
              2. Email<\/strong> \u2014 support@zappysys.com<\/li>\n
              3. Support Center<\/strong> \u2014 Visit the ZappySys Support Portal<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
                Introduction Notion is a popular workspace platform used by teams to manage projects, documentation, tasks, and databases in one place. Many organisations store operational data in Notion and need to migrate it to SQL Server for reporting, analytics, and business intelligence. Using Zappysys SSIS PowerPack, you can connect SSIS to Notion REST APIs and extract […]<\/p>\n","protected":false},"author":5,"featured_media":12167,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\r\nSSIS tutorial: How to get data from table in Notion | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS tutorial: How to get data from table in Notion - 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-get-data-from-table-in-notion\/\" \/>\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 get data from table in Notion | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS tutorial: How to get data from table in Notion - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-05-29T01:54:21+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-06-18T22:19:55+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"225\" \/>\r\n\t<meta property=\"og:image:height\" content=\"225\" \/>\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=\"6 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-get-data-from-table-in-notion\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/\",\"name\":\"SSIS tutorial: How to get data from table in Notion | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png\",\"datePublished\":\"2026-05-29T01:54:21+00:00\",\"dateModified\":\"2026-06-18T22:19:55+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS tutorial: How to get data from table in Notion - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png\",\"width\":225,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS tutorial: How to get data from table in Notion\"}]},{\"@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 get data from table in Notion | ZappySys Blog","description":"SSIS tutorial: How to get data from table in Notion - 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-get-data-from-table-in-notion\/","og_locale":"en_US","og_type":"article","og_title":"SSIS tutorial: How to get data from table in Notion | ZappySys Blog","og_description":"SSIS tutorial: How to get data from table in Notion - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/","og_site_name":"ZappySys Blog","article_published_time":"2026-05-29T01:54:21+00:00","article_modified_time":"2026-06-18T22:19:55+00:00","og_image":[{"width":225,"height":225,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/","name":"SSIS tutorial: How to get data from table in Notion | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png","datePublished":"2026-05-29T01:54:21+00:00","dateModified":"2026-06-18T22:19:55+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS tutorial: How to get data from table in Notion - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-logo.png","width":225,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-get-data-from-table-in-notion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS tutorial: How to get data from table in Notion"}]},{"@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\/12162"}],"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=12162"}],"version-history":[{"count":4,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12162\/revisions"}],"predecessor-version":[{"id":12266,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12162\/revisions\/12266"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12167"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}