{"id":11985,"date":"2026-04-15T00:17:49","date_gmt":"2026-04-15T00:17:49","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=11985"},"modified":"2026-04-16T17:36:00","modified_gmt":"2026-04-16T17:36:00","slug":"ssis-tutorial-how-to-claude-to-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/","title":{"rendered":"SSIS Tutorial: How to connect Claude to SSIS"},"content":{"rendered":"

<\/p>\n

Introduction<\/h2>\n

\"Cloud.IA\"<\/p>\n

Claude is a powerful cloud-native intelligence and automation platform that offers REST APIs for accessing AI models, data processing pipelines, and automation workflows. In this guide, we will demonstrate how to connect Zappysys SSIS connectors to the Claude using API key authentication.<\/p>\n

Whether you are using Claude for intelligent document processing, data enrichment, or automated workflows, you will learn how to configure SSIS integration without writing custom code. Zappysys handles all the complexity, allowing you to focus on building ETL workflows.<\/p>\n

<\/p>\n

Prerequisites<\/h2>\n
    \n
  1. \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. Claude.IA account with API access enabled.<\/li>\n
    4. Finally, do not forget to install\u00a0ZappySys\u00a0SSIS PowerPack.<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

      <\/p>\n

      Steps<\/h2>\n

      Generate an API Key in Claude<\/h3>\n
        \n
      1. Log in to your Claude.IA account settings.<\/a><\/li>\n
      2. Navigate to Settings<\/strong> > API Keys<\/strong>.<\/li>\n
      3. Click Create Key<\/strong>.<\/li>\n
      4. Enter the workspace name (optional).<\/li>\n
      5. Enter a descriptive name for the API key.<\/li>\n
      6. Press\u00a0Add<\/strong>\u00a0<\/strong>to generate the token Key.<\/span><\/li>\n
      7. Save the API key in a secure location; you won’t be able to view it again.\n
      8. Set Up Billing<\/strong> (required): add a payment method via the Billing Settings page<\/a>.<\/li>\n<\/ol>\n

        Create Zappysys Connection in SSIS<\/h3>\n
          \n
        1. Create or select your SSIS project and open the package.<\/li>\n
        2. Right-click in the Connection Managers<\/strong> pane and select New Connection…<\/strong><\/li>\n
        3. Select ZS-HTTP<\/strong> from the SSIS connectors list\n
        4. In Credentials Type<\/strong>, select Static token\/API key.<\/strong><\/li>\n
        5. Enter the API key from the previous step.<\/li>\n
        6. The API documentation requires sending the token in the header with this format: x-api-key: API_KEY<\/code>\n
            \n
          1. In the OAuth header Name<\/strong>, we will use x-api-key<\/strong><\/li>\n
          2. For the OAuth Scheme<\/strong>, set to none<\/strong><\/li>\n<\/ol>\n<\/li>\n
          3. Click OK <\/b>to save the settings.\n
            \"\"<\/a>

            Claude – HTTP connection<\/p><\/div><\/li>\n<\/ol>\n

            Create and Configure the JSON source<\/h3>\n
              \n
            1. \n
                \n
              1. In your SSIS package, drag and drop a Data Flow Task<\/strong> from the Toolbox into the Control Flow.\n
              2. Double-click the Data Flow Task to enter the Data Flow tab.<\/li>\n
              3. In the Data Flow, drag and drop a ZS JSON Source<\/strong><\/a> component from the Toolbox.<\/li>\n
              4. Double-click the JSON Source<\/strong><\/a> to open its editor.<\/li>\n
              5. Enable Use credentials,<\/strong> then select your Claude HTTP connection from the connection list dropdown.<\/li>\n
              6. Enter the following URL:\n
                https:\/\/api.anthropic.com\/v1\/messages<\/pre>\n<\/li>\n
              7. Select POST<\/strong> as an HTTP Request Method<\/strong><\/li>\n
              8. Inside the header, add: anthropic-version: 2023-06-01<\/span><\/li>\n
              9. In the Body content type, <\/strong>select\u00a0 JSON(application\/json)<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                  \n
                1. Use this as the body:\n
                  {\r\n  \"model\": \"claude-sonnet-4-6\",\r\n  \"max_tokens\": 1024,\r\n  \"messages\": [\r\n    {\r\n      \"role\": \"user\",\r\n      \"content\": \"{YOUR-Message}\"\r\n    }\r\n  ]\r\n}<\/pre>\n
                  <\/div>\n<\/li>\n
                2. Press on Preview<\/strong> to check the result.<\/li>\n
                3. You can use the Array filter<\/strong> to get the object you need, and you can use $.messages[*].content<\/span>\u00a0 to get only the message.<\/li>\n
                4. Click OK<\/strong> to save the configuration.\n
                  \"\"<\/a>
                  Claude – JSON source request<\/p><\/div><\/li>\n<\/ol>\n
                  Configure the Destination<\/h3>\n
                    \n
                  1. Drag and drop a destination component (e.g., Trash destination<\/strong>) into the Data Flow<\/strong>.<\/li>\n
                  2. Connect the output arrow from the JSON Source to the destination component.<\/li>\n
                  3. Double-click the destination component and configure it to point to your target table or file.<\/li>\n
                  4. Map the columns from the response to the appropriate destination columns<\/li>\n
                  5. Click OK<\/strong> to save the destination configuration.<\/li>\n
                  6. Execute the package and verify that the data extraction is working correctly.\n
                    \"\"<\/a>
                    Claude – Final Result<\/p><\/div><\/li>\n<\/ol>\n
                    <\/p>\n
                    Conclusion<\/h2>\n
                    You now have a secure and reliable connection between Zappysys SSIS and Claude. API Key authentication is simpler to set up with our HTTP connection. With this connection configured, you can build powerful data extraction, transformation, and loading workflows using Claude’s intelligence and automation capabilities directly from your SSIS packages without writing any custom 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
                    <\/p>\n
                    <\/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 Claude is a powerful cloud-native intelligence and automation platform that offers REST APIs for accessing AI models, data processing pipelines, and automation workflows. In this guide, we will demonstrate how to connect Zappysys SSIS connectors to the Claude using API key authentication. Whether you are using Claude for intelligent document processing, data enrichment, or […]<\/p>\n","protected":false},"author":5,"featured_media":11987,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\r\nSSIS Tutorial: How to connect Claude to SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS Tutorial: How to connect Claude to 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-claude-to-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 Claude to SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS Tutorial: How to connect Claude to SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-04-15T00:17:49+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2026-04-16T17:36:00+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\r\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\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=\"5 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-claude-to-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/\",\"name\":\"SSIS Tutorial: How to connect Claude to SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png\",\"datePublished\":\"2026-04-15T00:17:49+00:00\",\"dateModified\":\"2026-04-16T17:36:00+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"SSIS Tutorial: How to connect Claude to SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png\",\"width\":1024,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Tutorial: How to connect Claude to 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 Claude to SSIS | ZappySys Blog","description":"SSIS Tutorial: How to connect Claude to 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-claude-to-ssis\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Tutorial: How to connect Claude to SSIS | ZappySys Blog","og_description":"SSIS Tutorial: How to connect Claude to SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/","og_site_name":"ZappySys Blog","article_published_time":"2026-04-15T00:17:49+00:00","article_modified_time":"2026-04-16T17:36:00+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/","url":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/","name":"SSIS Tutorial: How to connect Claude to SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png","datePublished":"2026-04-15T00:17:49+00:00","dateModified":"2026-04-16T17:36:00+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"SSIS Tutorial: How to connect Claude to SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/04\/Claude-ai-logo.png","width":1024,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-tutorial-how-to-claude-to-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Tutorial: How to connect Claude to 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\/11985"}],"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=11985"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11985\/revisions"}],"predecessor-version":[{"id":12026,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/11985\/revisions\/12026"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11987"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=11985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=11985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=11985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}