{"id":2191,"date":"2017-10-18T17:39:37","date_gmt":"2017-10-18T17:39:37","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=2191"},"modified":"2019-09-27T14:30:07","modified_gmt":"2019-09-27T14:30:07","slug":"ssis-generate-xml-namespace-prefix","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/","title":{"rendered":"How to generate XML with namespace \/ prefix in SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"In this post you will see how to generate XML which has namespace and prefix for elements. We will use SSIS XML Generator Transform<\/a> for this purpose. Common pattern would be generate XML SOAP message using XML Generator Transform and send to Web service using SSIS Web API Destination<\/a>. For full tutorial on how to export XML using SSIS check this link<\/a>.<\/p>\n

 <\/p>\n

Understanding XML Namespace and Prefix<\/h2>\n

Just like how many programming languages offer concept called namespace to avoid similar name conflict for classes, XML also has namespace<\/a> concept.<\/p>\n

Sample XML with namespace and prefix<\/strong><\/p>\n

<?xml version=\"1.0\"?>\r\n<soapenv:Envelope xmlns:p1=\"http:\/\/someurl-1\" xmlns:soapenv=\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\">\r\n\t<soapenv:Body>\r\n\t\t<p1:CustomerID>CID1<\/p1:CustomerID>\r\n\t\t<p1:CompanyName>some company name<\/p1:CompanyName>\r\n\t<\/soapenv:Body>\r\n<\/soapenv:Envelope><\/pre>\n
If you notice in above XML there are two important things. Under <soapenv:Envelope><\/strong> element you have\u00a0xmlns:p1<\/strong> and\u00a0xmlns:soapenv<\/strong> attributes. Basically these are two namespace declarations and they both use different prefix (i.e. p1 and soapenv). Once you define namespace prefix you can use in the declaring element or any child element under that node.<\/p>\n
Syntax for XML Namespace declaration:<\/strong><\/p>\n
xmlns:yourprefix=\"url or unique identifier\"<\/pre>\n
Example – Using SSIS XML Generator Transform<\/h2>\n
Now lets look at how to generate XML using SSIS XML Generator Transform. This same technique can be used by SSIS Export XML Task.<\/p>\n
    \n
  1. Download and Install SSIS PowerPack from here<\/a> (Skip this if you already did)<\/li>\n
  2. Open Visual Studio and create new SSIS Package<\/li>\n
  3. Drag Data Flow Task from Control Flow Toolbox\n
    \"\"
    Dragging and dropping Data Flow Task into Control Flow<\/p><\/div><\/li>\n
  4. Drag ZS Dummy Data Source<\/a> (You can use any source you like. e.g. OLEDB Source)<\/li>\n
  5. Change Template to Customer to create fake customer data. Click OK to save.<\/li>\n
  6. Now drag and drop ZS XML Generator Transform<\/a><\/li>\n
  7. Connect Source to XML Generator<\/li>\n
  8. Double click XML Generator to configure.<\/li>\n
  9. Go to Options tab and change following setting\n
      \n
    1. under Namespaces define two namespaces as below (Change p1 to desired prefix)
      \np1=http:\/\/someurl, soapenv=http:\/\/schemas.xmlsoap.org\/soap\/envelope\/<\/li>\n
    2. Change Root element name to Envelope<\/li>\n
    3. Change Root Element Prefix to soapenv\n
    4. Now go to layout tab and select dataset and click Edit<\/li>\n
    5. Change default Row element name to Body and prefix to soapenv as below. Click OK to save\n
    6. Now right click on Mappings folder and Click “Add Elements” or click in the toolbar icon.<\/li>\n
    7. On the Add Elements dialog\n
        \n
      1. select Add multiple option.<\/li>\n
      2. Change Prefix to p1 (or whatever you entered before on Options tab)<\/li>\n
      3. Select columns you want to output in XML\n
      4. Now you will see preview update for your XML layout as below\n
      5. Now attach your XML Generator Transform to some downstream component such as ZS Trash Destination and run the package<\/li>\n<\/ol>\n
         <\/p>\n
        Conclusion<\/h2>\n
        Using SSIS PowerPack you can generate complex XML in few clicks. Download SSIS PowerPack<\/a> for FREE Trial and discover many more features.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Introduction In this post you will see how to generate XML which has namespace and prefix for elements. We will use SSIS XML Generator Transform for this purpose. Common pattern would be generate XML SOAP message using XML Generator Transform and send to Web service using SSIS Web API Destination. For full tutorial on how […]<\/p>\n","protected":false},"author":1,"featured_media":2206,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[137,132],"tags":[12,247,4,189,7],"yoast_head":"\r\nHow to generate XML with namespace \/ prefix in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Generate XML in few click using SSIS XML Generator Transform. Learn how to define namespace and prefix. POST your Data to SOAP Service in few clicks.\" \/>\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-generate-xml-namespace-prefix\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to generate XML with namespace \/ prefix in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Generate XML in few click using SSIS XML Generator Transform. Learn how to define namespace and prefix. POST your Data to SOAP Service in few clicks.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-10-18T17:39:37+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-09-27T14:30:07+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"110\" \/>\r\n\t<meta property=\"og:image:height\" content=\"110\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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-generate-xml-namespace-prefix\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/\",\"name\":\"How to generate XML with namespace \/ prefix in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png\",\"datePublished\":\"2017-10-18T17:39:37+00:00\",\"dateModified\":\"2019-09-27T14:30:07+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Generate XML in few click using SSIS XML Generator Transform. Learn how to define namespace and prefix. POST your Data to SOAP Service in few clicks.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png\",\"width\":110,\"height\":110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to generate XML with namespace \/ prefix in 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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to generate XML with namespace \/ prefix in SSIS | ZappySys Blog","description":"Generate XML in few click using SSIS XML Generator Transform. Learn how to define namespace and prefix. POST your Data to SOAP Service in few clicks.","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-generate-xml-namespace-prefix\/","og_locale":"en_US","og_type":"article","og_title":"How to generate XML with namespace \/ prefix in SSIS | ZappySys Blog","og_description":"Generate XML in few click using SSIS XML Generator Transform. Learn how to define namespace and prefix. POST your Data to SOAP Service in few clicks.","og_url":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-10-18T17:39:37+00:00","article_modified_time":"2019-09-27T14:30:07+00:00","og_image":[{"width":110,"height":110,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/","url":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/","name":"How to generate XML with namespace \/ prefix in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png","datePublished":"2017-10-18T17:39:37+00:00","dateModified":"2019-09-27T14:30:07+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Generate XML in few click using SSIS XML Generator Transform. Learn how to define namespace and prefix. POST your Data to SOAP Service in few clicks.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/10\/ssis-xml-generator-transform.png","width":110,"height":110},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-generate-xml-namespace-prefix\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to generate XML with namespace \/ prefix in 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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2191"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=2191"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2191\/revisions"}],"predecessor-version":[{"id":8068,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/2191\/revisions\/8068"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/2206"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=2191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=2191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=2191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}