![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/notion-logo.png\"){kind=logo}
<\/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>\nUsing 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>\nPrerequisites<\/h2>\n\n- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
- A Notion workspace with at least one database and records.<\/li>\n
- Zappysys SSIS PowerPack<\/a> is installed on your system.<\/li>\n<\/ol>\n
Steps<\/h2>\nCreate a Notion Integration and Token<\/h3>\n\n- Go to Notion Integrations<\/a> and sign in.<\/li>\n
- Click New integration<\/strong>.<\/li>\n
- Enter a name for your integration and select the target workspace.<\/li>\n
- Click Create connection<\/b> to proceed.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Create-a-new-connection.png\")
<\/a>Notion – Create a new connection<\/p><\/div><\/li>\n
- Configure the capabilities<\/strong> you need by checking or unchecking the relevant options.<\/li>\n
- Copy the generated Access Token<\/strong> and store it securely.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Configure-new-token.png\")
<\/a>Notion – Configure new token<\/p><\/div><\/li>\n
- 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- Open your target Notion database page in the browser.<\/li>\n
- Click …<\/strong> in the top-right corner.<\/li>\n
- Click Connections<\/strong>, search for your connection, and select it.<\/li>\n
- Confirm access to the connection.<\/li>\n
- Copy the database ID from the URL. For example:<\/li>\n
- Set URL<\/strong> to:\n
https:\/\/app.notion.com\/p\/<<DATABASE_ID>>?v=..........<\/pre>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Set-a-connection-to-your-table.png\")
<\/a>Notion – Set a connection to your table<\/p><\/div><\/li>\n<\/ol>\n
Create an HTTP connection in SSIS<\/h3>\n\n- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and choose New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Create-a-new-HTTP-connection.png\")
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
- Paste your Notion Access token<\/strong> in the token value field.<\/li>\n
- Click OK<\/strong> to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Connection-configuration-1.png\")
<\/a>Notion – Connection configuration<\/p><\/div><\/li>\n<\/ol>\n
Create and Configure REST API Source<\/h3>\n\n- Add a Data Flow Task<\/strong> to the Control Flow and double-click to open it.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\")
<\/a>Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the Notion HTTP connection you created earlier.<\/li>\n
- Set URL<\/strong> to:\n
https:\/\/api.notion.com\/v1\/databases\/{{User::DatabaseId}}\/query<\/pre>\n<\/li>\n- Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
- Under headers, add: Notion-Version: {NotionVersion}. (Example: 2022-06-28)<\/li>\n
- Set JSON Path Filter<\/strong> to extract the object array. Example: $.results[*]<\/li>\n
- Click Preview<\/strong> to confirm rows are returned, then click OK<\/strong> to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-JSON-source-configuration.png\")
<\/a>Notion – JSON source configuration<\/p><\/div>\n
<\/div>\n<\/li>\n<\/ol>\nConfigure the destination and run the package<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Notion database data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- \n
- SQL Server Integration Services (SSIS) is installed.<\/li>\n
- Visual Studio with SSIS extension or SQL Server Data Tools (SSDT).<\/li>\n
- A Notion workspace with at least one database and records.<\/li>\n
- 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
- Go to Notion Integrations<\/a> and sign in.<\/li>\n
- Click New integration<\/strong>.<\/li>\n
- Enter a name for your integration and select the target workspace.<\/li>\n
- Click Create connection<\/b> to proceed.\n
<\/a>Notion – Create a new connection<\/p><\/div><\/li>\n
- Configure the capabilities<\/strong> you need by checking or unchecking the relevant options.<\/li>\n
- Copy the generated Access Token<\/strong> and store it securely.\n
<\/a>Notion – Configure new token<\/p><\/div><\/li>\n
- 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
- Open your target Notion database page in the browser.<\/li>\n
- Click …<\/strong> in the top-right corner.<\/li>\n
- Click Connections<\/strong>, search for your connection, and select it.<\/li>\n
- Confirm access to the connection.<\/li>\n
- Copy the database ID from the URL. For example:<\/li>\n
- 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
- Create or open your SSIS project and package.<\/li>\n
- In Connection Managers<\/strong>, right-click and choose New Connection…<\/strong><\/li>\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
<\/a>Create a new HTTP connection<\/p><\/div><\/li>\n
- Set Credentials Type<\/strong> to Static token\/API key<\/strong>.<\/li>\n
- Paste your Notion Access token<\/strong> in the token value field.<\/li>\n
- 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
- Add a Data Flow Task<\/strong> to the Control Flow and double-click to open it.\n<\/a>
Drag and drop Data flow<\/p><\/div><\/li>\n
- In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/div><\/li>\n
- Open the JSON Source editor and enable Use credentials<\/strong>.<\/li>\n
- Select the Notion HTTP connection you created earlier.<\/li>\n
- Set URL<\/strong> to:\n
https:\/\/api.notion.com\/v1\/databases\/{{User::DatabaseId}}\/query<\/pre>\n<\/li>\n- Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
- Under headers, add: Notion-Version: {NotionVersion}. (Example: 2022-06-28)<\/li>\n
- Set JSON Path Filter<\/strong> to extract the object array. Example: $.results[*]<\/li>\n
- 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>\nConfigure the destination and run the package<\/h3>\n
- \n
- Drag and drop a destination component (such as OLE DB Destination<\/strong>, Flat File Destination<\/strong>, or Trash Destination<\/strong>) into the Data Flow.<\/li>\n
- Connect the output arrow from the JSON Source component to the destination component.<\/li>\n
- Double-click the destination component to open its configuration dialogue.<\/li>\n
- Configure the destination to point to your target table or file where Notion database data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding destination columns.<\/li>\n
- Click OK<\/strong> to save the destination configuration.<\/li>\n
- Execute the package and verify that the data extraction is working correctly.\n
- In Data Flow, drag and drop the ZS JSON Source<\/strong><\/a>.\n
- Select ZS-HTTP<\/strong> from the SSIS connectors list.\n
- Click Connections<\/strong>, search for your connection, and select it.<\/li>\n
- Click New integration<\/strong>.<\/li>\n
- Go to Notion Integrations<\/a> and sign in.<\/li>\n