![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/trello-logo.png\"){kind=logo}
<\/a>Trello is a popular project management platform used by teams worldwide to organize tasks, track progress, and collaborate on projects. Many organizations need to integrate Trello data with SQL Server for reporting, analytics, and business intelligence purposes. Using Zappysys SSIS PowerPack, you can easily extract card data, lists, and board information from Trello using REST APIs without writing custom code.<\/p>\nThis tutorial demonstrates how to connect SSIS to Trello and load card and board data into SQL Server tables using the Zappysys REST API Source component.<\/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 Trello account with at least one board and list created.<\/li>\n
- Zappysys SSIS PowerPack<\/a> installed on your system.<\/li>\n<\/ol>\n
Steps
\nGenerate Trello API Key and Token<\/h2>\n\n- Go to the Trello Power-up page<\/a> and log in to your account.<\/li>\n
- Create a new App and fill in the form.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Trello-Create-a-new-App.png\")
<\/a>Trello – Create a new App<\/p><\/p><\/div><\/li>\n
- Inside your new App, click the API key<\/strong>, then generate a new API Key.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/trello-API-key-page.png\")
<\/a>Trello – API key page<\/p><\/p><\/div><\/li>\n
- In the API Key section, click the Token<\/strong> link to generate an access token.\n<\/div>\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Trello-API-key-and-Token-link.png\")
<\/a>Trello – API key and Token link<\/p><\/div><\/li>\n
- Choose the token’s expiration time (Recommended: 30 days for security).<\/li>\n
- Review the permissions and click Create Token<\/strong>.<\/li>\n
- Copy the generated token and store it securely.<\/li>\n
- You now have both your API Key and Token. Keep these credentials confidential.<\/li>\n<\/ol>\n
Configure SSIS Package Variables<\/h3>\n\n- Open your SSIS project in Visual Studio or SQL Server Data Tools (SSDT).<\/li>\n
- Create a new package or open an existing one.<\/li>\n
- Navigate to the Variables<\/strong> section and create the following variables:\n
\n- TrelloApiKey<\/b> (String) \u2014 Enter the API Key you generated in the previous step.<\/li>\n
- TrelloToken<\/b> (String) \u2014 Enter the access token you created.<\/li>\n
- BoardId<\/b> (String) \u2014 Enter your Trello Board ID.<\/li>\n<\/ol>\n<\/li>\n
- Ensure all variables are marked as sensitive if they contain authentication credentials to secure the package.<\/li>\n<\/ol>\n
Create and Configure the\u00a0 JSON Source<\/h3>\n\n- \n
\n- Add a new Data Flow Task<\/strong> to your SSIS package.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/02\/Drag-and-drop-Data-flow.png\")
<\/a>Drag and drop Data flow<\/p><\/p><\/div><\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/09\/ssis-json-source-adapter-drag.png\")
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong> to open its configuration editor.<\/li>\n
- In the Connection<\/strong> section, enter the Trello API endpoint to retrieve cards from your board:\n
https:\/\/api.trello.com\/1\/members\/me\/boards?key={{User::TrelloApiKey}}&token={{User::TrelloToken}}<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click Test Connection<\/strong> to verify that your API credentials are correct and you can access your Trello board data.<\/li>\n
- Click Preview Data<\/strong> to view the card data that will be extracted from Trello.<\/li>\n
- Click OK<\/strong> to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Trello-JSON-source-example.png\")
<\/a>Trello – JSON source example<\/p><\/p><\/div><\/li>\n
- Alternatively, you can use the
boardId<\/code> parameter in the request to retrieve specific board data. Here are some common API endpoints:
\nGET \/boards\/{boardId}\/cards \u2014 Retrieve all cards from a specific board<\/code>
\nGET \/boards\/{boardId}\/lists \u2014 Retrieve all lists from a specific board<\/code>
\nGET \/cards\/{cardId} \u2014 Retrieve details of a specific card<\/code><\/p>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Trello-JSON-source-example-board-id.png\")
<\/a>Trello – JSON source example board ID<\/p><\/div><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n\n- Drag and drop a destination component (such as OLE DB Destination<\/strong>, SQL Server Destination<\/strong>, or Flat File 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 dialog.<\/li>\n
- Configure the connection manager to point to your target SQL Server database.<\/li>\n
- In the destination editor, specify the target table where Trello data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding SQL Server table columns.<\/li>\n
- Configure error-handling options based on your requirements (fail on errors, ignore errors, or redirect error rows to an error table).<\/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 Trello account with at least one board and list created.<\/li>\n
- Zappysys SSIS PowerPack<\/a> installed on your system.<\/li>\n<\/ol>\n
Steps
\nGenerate Trello API Key and Token<\/h2>\n- \n
- Go to the Trello Power-up page<\/a> and log in to your account.<\/li>\n
- Create a new App and fill in the form.\n
<\/a>Trello – Create a new App<\/p><\/p><\/div><\/li>\n
- Inside your new App, click the API key<\/strong>, then generate a new API Key.\n
<\/a>Trello – API key page<\/p><\/p><\/div><\/li>\n
- In the API Key section, click the Token<\/strong> link to generate an access token.\n
<\/div>\n<\/a>Trello – API key and Token link<\/p><\/div><\/li>\n
- Choose the token’s expiration time (Recommended: 30 days for security).<\/li>\n
- Review the permissions and click Create Token<\/strong>.<\/li>\n
- Copy the generated token and store it securely.<\/li>\n
- You now have both your API Key and Token. Keep these credentials confidential.<\/li>\n<\/ol>\n
Configure SSIS Package Variables<\/h3>\n
- \n
- Open your SSIS project in Visual Studio or SQL Server Data Tools (SSDT).<\/li>\n
- Create a new package or open an existing one.<\/li>\n
- Navigate to the Variables<\/strong> section and create the following variables:\n
- \n
- TrelloApiKey<\/b> (String) \u2014 Enter the API Key you generated in the previous step.<\/li>\n
- TrelloToken<\/b> (String) \u2014 Enter the access token you created.<\/li>\n
- BoardId<\/b> (String) \u2014 Enter your Trello Board ID.<\/li>\n<\/ol>\n<\/li>\n
- Ensure all variables are marked as sensitive if they contain authentication credentials to secure the package.<\/li>\n<\/ol>\n
Create and Configure the\u00a0 JSON Source<\/h3>\n
- \n
- \n
- \n
- Add a new Data Flow Task<\/strong> to your SSIS package.<\/li>\n
- Double-click the Data Flow Task to enter the Data Flow design surface.\n
<\/a>Drag and drop Data flow<\/p><\/p><\/div><\/li>\n
- Drag a ZappySys JSON Source<\/a> component from the toolbox onto the canvas.\n
<\/a>SSIS JSON Source – Drag and Drop<\/p><\/p><\/div><\/li>\n
- Double-click the ZappySys JSON Source<\/strong> to open its configuration editor.<\/li>\n
- In the Connection<\/strong> section, enter the Trello API endpoint to retrieve cards from your board:\n
https:\/\/api.trello.com\/1\/members\/me\/boards?key={{User::TrelloApiKey}}&token={{User::TrelloToken}}<\/pre>\n<\/li>\n- Set the HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Click Test Connection<\/strong> to verify that your API credentials are correct and you can access your Trello board data.<\/li>\n
- Click Preview Data<\/strong> to view the card data that will be extracted from Trello.<\/li>\n
- Click OK<\/strong> to save the configuration.\n
<\/a>Trello – JSON source example<\/p><\/p><\/div><\/li>\n
- Alternatively, you can use the
boardId<\/code> parameter in the request to retrieve specific board data. Here are some common API endpoints:
\nGET \/boards\/{boardId}\/cards \u2014 Retrieve all cards from a specific board<\/code>
\nGET \/boards\/{boardId}\/lists \u2014 Retrieve all lists from a specific board<\/code>
\nGET \/cards\/{cardId} \u2014 Retrieve details of a specific card<\/code><\/p>\n<\/a>Trello – JSON source example board ID<\/p><\/div><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
Configure the Data Destination<\/h3>\n
- \n
- Drag and drop a destination component (such as OLE DB Destination<\/strong>, SQL Server Destination<\/strong>, or Flat File 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 dialog.<\/li>\n
- Configure the connection manager to point to your target SQL Server database.<\/li>\n
- In the destination editor, specify the target table where Trello data will be stored.<\/li>\n
- In the Mappings<\/strong> section, map the columns from the JSON response to the corresponding SQL Server table columns.<\/li>\n
- Configure error-handling options based on your requirements (fail on errors, ignore errors, or redirect error rows to an error table).<\/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
- Double-click the Data Flow Task to enter the Data Flow design surface.\n
- Add a new Data Flow Task<\/strong> to your SSIS package.<\/li>\n
- TrelloToken<\/b> (String) \u2014 Enter the access token you created.<\/li>\n
- TrelloApiKey<\/b> (String) \u2014 Enter the API Key you generated in the previous step.<\/li>\n
- Create a new App and fill in the form.\n
- Go to the Trello Power-up page<\/a> and log in to your account.<\/li>\n