{"id":12697,"date":"2022-10-13T06:29:04","date_gmt":"2022-10-13T04:29:04","guid":{"rendered":"https:\/\/expert-only.com\/?p=12697"},"modified":"2022-10-19T18:40:41","modified_gmt":"2022-10-19T16:40:41","slug":"importer-un-fichier-xml-avec-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/","title":{"rendered":"Importer un fichier XML dans une table avec SSIS"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-importer-un-fichier-au-format-xml-dans-une-table-sql-server-avec-un-package-ssis\"><strong><em>Importer un fichier au format XML dans une table SQL Server avec un package SSIS.<\/em><\/strong><\/h4>\n\n\n\n<p>Pour importer un fichier au format XML, il est n\u00e9cessaire de fournir le sch\u00e9ma au format XSD qui repr\u00e9sente la structure du fichier. Dans ce cas pr\u00e9cis, le fichier XSD est g\u00e9n\u00e9r\u00e9 automatiquement par Visual Studio et Integration Services. Ce tutoriel explique pas \u00e0 pas comment importer un fichier XML dans une table SQL avec <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/integration-services\/data-flow\/xml-source?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">le composant natif XML Source<\/a>.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#1-preparer-la-table-des-clients-avec-ssms-et-le-fichier-xml-a-importer\" >1. Pr\u00e9parer la table des clients avec SSMS et le fichier XML \u00e0 importer<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#2-configurer-la-source-xml-depuis-le-flux-de-donnees-ssis\" >2. Configurer la source XML depuis le flux de donn\u00e9es SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#3-erreur-ssis-no-maximum-length-was-specified-for-the-xml-source\" >3. Erreur SSIS No maximum length was specified for the XML Source<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#4-configurer-la-connexion-a-la-table-de-destination\" >4. Configurer la connexion \u00e0 la table de destination<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#5-executer-le-package-pour-importer-les-donnees-xml\" >5. Ex\u00e9cuter le package pour importer les donn\u00e9es XML<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#6-conclusion-sur-limport-de-donnees-au-format-xml-avec-ssis\" >6. Conclusion sur l&rsquo;import de donn\u00e9es au format XML avec SSIS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-preparer-la-table-des-clients-avec-ssms-et-le-fichier-xml-a-importer\"><\/span>1. Pr\u00e9parer la table des clients avec SSMS et le fichier XML \u00e0 importer <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La table de destination est la table des clients avec une structure basique. Voici le code SQL Server pour la cr\u00e9er depuis une connexion \u00e0 la base cible avec SSMS.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cr\u00e9er la table des clients\nCREATE TABLE [dbo].[Customers](\n   [CustomerID] [int] NOT NULL,\n   [FirstName] [nvarchar](20) NULL,\n   [LastName] [nvarchar](20) NULL,\n   [City] [nvarchar](20) NULL,\n   [Country] [nvarchar](50) NULL,\n   CONSTRAINT [CustomersPrimaryKeyCustomerID] PRIMARY KEY CLUSTERED ([CustomerID] ASC)\n);\nGO<\/pre>\n\n\n\n<p>T\u00e9l\u00e9charger le fichier XML utilis\u00e9 dans ce tutoriel depuis le lien ci-dessous. En raison de restrictions, le fichier est renomm\u00e9 en txt et avec des commentaires. Renommer donc le fichier en <em>Customers_Data.csv<\/em> et enlever les commentaires, c&rsquo;est \u00e0 dire supprimer la premi\u00e8re et la derni\u00e8re ligne du fichier. <\/p>\n\n\n\n<div class=\"wp-block-file aligncenter\"><a id=\"wp-block-file--media-f062501e-5fe5-4dd9-bdee-e1ed4bf5b3b5\" href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/Customers_Data.txt\"><strong>Customers_Data.txt<\/strong><\/a><a href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/Customers_Data.txt\" class=\"wp-block-file__button\" download aria-describedby=\"wp-block-file--media-f062501e-5fe5-4dd9-bdee-e1ed4bf5b3b5\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<p>En cas de difficult\u00e9 pour t\u00e9l\u00e9charger et utiliser le fichier, voici un \u00e9chantillon du fichier au format XML avec uniquement les 6 premi\u00e8res lignes.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?>\n&lt;Customers>\n\t&lt;Customer>\n\t\t&lt;CustomerID>1&lt;\/CustomerID>\n\t\t&lt;FirstName>Ali&lt;\/FirstName>\n\t\t&lt;LastName>Ahmed&lt;\/LastName>\n\t\t&lt;City>Cairo&lt;\/City>\n\t\t&lt;Country>Egypt&lt;\/Country>\n\t&lt;\/Customer>\n\t&lt;Customer>\n\t\t&lt;CustomerID>2&lt;\/CustomerID>\n\t\t&lt;FirstName>Johnny&lt;\/FirstName>\n\t\t&lt;LastName>John&lt;\/LastName>\n\t\t&lt;City>Toronto&lt;\/City>\n\t\t&lt;Country>Canada&lt;\/Country>\n\t&lt;\/Customer>\n\t&lt;Customer>\n\t\t&lt;CustomerID>3&lt;\/CustomerID>\n\t\t&lt;FirstName>John&lt;\/FirstName>\n\t\t&lt;LastName>Doe&lt;\/LastName>\n\t\t&lt;City>Mexico City&lt;\/City>\n\t\t&lt;Country>Mexico&lt;\/Country>\n\t&lt;\/Customer>\n\t&lt;Customer>\n\t\t&lt;CustomerID>4&lt;\/CustomerID>\n\t\t&lt;FirstName>Shu&lt;\/FirstName>\n\t\t&lt;LastName>Abbas&lt;\/LastName>\n\t\t&lt;City>Paris&lt;\/City>\n\t\t&lt;Country>France&lt;\/Country>\n\t&lt;\/Customer>\n\t&lt;Customer>\n\t\t&lt;CustomerID>5&lt;\/CustomerID>\n\t\t&lt;FirstName>Jeane&lt;\/FirstName>\n\t\t&lt;LastName>Raffin&lt;\/LastName>\n\t\t&lt;City>Liushutun&lt;\/City>\n\t\t&lt;Country>China&lt;\/Country>\n\t&lt;\/Customer>\n\t&lt;Customer>\n\t\t&lt;CustomerID>6&lt;\/CustomerID>\n\t\t&lt;FirstName>Legra&lt;\/FirstName>\n\t\t&lt;LastName>Leate&lt;\/LastName>\n\t\t&lt;City>B\u0142aszki&lt;\/City>\n\t\t&lt;Country>Poland&lt;\/Country>\n\t&lt;\/Customer>\n&lt;\/Customers><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-configurer-la-source-xml-depuis-le-flux-de-donnees-ssis\"><\/span>2. Configurer la source XML depuis le flux de donn\u00e9es SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cr\u00e9er au pr\u00e9alable <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">un package SSIS dans un projet<\/a>, et y ajouter <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-data-flow-ssis-simple\/\">un flux de donn\u00e9es<\/a>. Ajouter ensuite les composants <em>XML Source<\/em> et <em>OLE DB Destination<\/em> dans le flux de donn\u00e9es SSIS.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-1-add-xml-source-ole-db-destination.jpg\" alt=\"Utiliser les composants XML Source et OLE DB Destination pour importer un fichier XML\" class=\"wp-image-12716\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-1-add-xml-source-ole-db-destination.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-1-add-xml-source-ole-db-destination-300x281.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption>Utiliser les composants XML Source et OLE DB Destination pour importer un fichier XML<\/figcaption><\/figure><\/div>\n\n\n<p>Ouvrir le composant XML et pointer vers le fichier XML.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>S\u00e9lectionner le chemin du fichier XML \u00e0 importer : <strong><em>C:\\data\\Customers_Data.xml<\/em><\/strong><\/li><li>Utiliser <em>Generate XSD<\/em> et choisir le chemin du fichier: <strong><em>C:\\data\\Customers_Data_VisualStudio.xsd<\/em><\/strong><\/li><li>Cliquer sur <em>Columns<\/em> pour v\u00e9rifier le mapping<\/li><\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-2-select-source-generate-xsd-schema-1.jpg\" alt=\"Param\u00e9trer le fichier XML source \u00e0 importer dans la base et le sch\u00e9ma XSD avec SSIS\" class=\"wp-image-12734\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-2-select-source-generate-xsd-schema-1.jpg 830w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-2-select-source-generate-xsd-schema-1-300x159.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-2-select-source-generate-xsd-schema-1-768x407.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><figcaption>Param\u00e9trer le fichier XML source \u00e0 importer dans la base et le sch\u00e9ma XSD avec SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>Le sch\u00e9ma XSD n&rsquo;indique pas la longueur des champs par d\u00e9faut et le package assigne donc le type DT_WSTR avec une longueur de 255 caract\u00e8res. Soit le type de donn\u00e9es SSIS (DT_WSTR,255). Le package affiche donc ce message d&rsquo;avertissement:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"572\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-3-no-maximum-length-error.jpg\" alt=\"Erreur XML SSIS No maximum length was specified for the XML Source\" class=\"wp-image-12741\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-3-no-maximum-length-error.jpg 809w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-3-no-maximum-length-error-300x212.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-3-no-maximum-length-error-768x543.jpg 768w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><figcaption>Erreur XML SSIS No maximum length was specified for the XML Source<\/figcaption><\/figure><\/div>\n\n\n<p><em>Warning at {EF1A3256-9D27-4D85-9F3A-570513FF215F} [XML Source [69]]: No maximum length was specified for the XML Source.Outputs[Customer].Columns[FirstName] with external data type System.String. The SSIS Data Flow Task data type \u00ab\u00a0DT_WSTR\u00a0\u00bb with a length of 255 will be used.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-erreur-ssis-no-maximum-length-was-specified-for-the-xml-source\"><\/span>3. Erreur SSIS No maximum length was specified for the XML Source<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce n&rsquo;est qu&rsquo;un message d&rsquo;avertissement mais il est possible de corriger le probl\u00e8me. Pour cela, modifier le fichier XSD et indiquer les longueurs pour tous les champs textes. Le fichier XSD g\u00e9n\u00e9r\u00e9 automatiquement par Visual Studio est de ce type: <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"560\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-4-generated-xsd-file.jpg\" alt=\"Fichier de sch\u00e9ma XSD g\u00e9n\u00e9r\u00e9 automatiquement dans XML Source de Visual Studio\" class=\"wp-image-12748\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-4-generated-xsd-file.jpg 1000w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-4-generated-xsd-file-300x168.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-4-generated-xsd-file-768x430.jpg 768w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-4-generated-xsd-file-678x381.jpg 678w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption>Fichier de sch\u00e9ma XSD g\u00e9n\u00e9r\u00e9 automatiquement dans XML Source de Visual Studio<\/figcaption><\/figure><\/div>\n\n\n<p>La ligne d&rsquo;\u00e9l\u00e9ment XML ne contient pas la propri\u00e9t\u00e9 <em><strong>maxLength<\/strong><\/em>. Remplacer chaque ligne de ce type: <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;xs:element minOccurs=\"0\" name=\"FirstName\" type=\"xs:string\" \/><\/pre>\n\n\n\n<p>Par un bloc avec la longueur explicite du champs texte, par exemple: <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"xml\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;xs:element minOccurs=\"0\" name=\"FirstName\" >\n &lt;xs:simpleType>\n   &lt;xs:restriction base=\"xs:string\">\n\t  &lt;xs:minLength value=\"0\"\/>\n\t  &lt;xs:maxLength value=\"20\"\/>\n   &lt;\/xs:restriction>\n &lt;\/xs:simpleType>\n&lt;\/xs:element><\/pre>\n\n\n\n<p>Le r\u00e9sultat est un fichier avec la longueur correspondante \u00e0 chaque colonne de la table SQL. Ainsi le fichier modifi\u00e9 indique la longueur de chaque champs texte XML, comme sur la capture ci-dessous.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"990\" height=\"650\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-5-update-xsd-schema-add-length.jpg\" alt=\"Mettre \u00e0 jour le fichier XSD avec la propri\u00e9t\u00e9 maxLength \" class=\"wp-image-12757\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-5-update-xsd-schema-add-length.jpg 990w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-5-update-xsd-schema-add-length-300x197.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-5-update-xsd-schema-add-length-768x504.jpg 768w\" sizes=\"auto, (max-width: 990px) 100vw, 990px\" \/><figcaption>Mettre \u00e0 jour le fichier XSD avec la propri\u00e9t\u00e9 maxLength <\/figcaption><\/figure><\/div>\n\n\n<p>Enregistrer le nouveau fichier XSD, comme sous <strong><em>C:\\data\\Customers_Data.xsd<\/em><\/strong>. Pointer enfin le composant XML SSIS vers le nouveau sch\u00e9ma XML.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-6-setup-xsd-schema.jpg\" alt=\"Configurer le fichier XML \u00e0 importer avec SSIS avec le nouveau fichier XSD \" class=\"wp-image-12764\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-6-setup-xsd-schema.jpg 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-6-setup-xsd-schema-300x189.jpg 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption>Configurer le fichier XML \u00e0 importer avec SSIS avec le nouveau fichier XSD <\/figcaption><\/figure><\/div>\n\n\n<p>Une fois l&rsquo;avertissement corrig\u00e9, v\u00e9rifier le mapping des colonnes dans le composant source.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-7-check-xml-mapping.jpg\" alt=\"V\u00e9rifier les colonnes du fichier XML \u00e0 importer avec SSIS\" class=\"wp-image-12770\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-7-check-xml-mapping.jpg 540w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-7-check-xml-mapping-279x300.jpg 279w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><figcaption>V\u00e9rifier les colonnes du fichier XML \u00e0 importer avec SSIS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-configurer-la-connexion-a-la-table-de-destination\"><\/span>4. Configurer la connexion \u00e0 la table de destination<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ouvrir le composant <em>OLE DB Destination<\/em> et choisir la table dans laquelle importer le fichier XML. C&rsquo;est donc la table <em>dbo.Customers<\/em> cr\u00e9\u00e9e \u00e0 l&rsquo;\u00e9tape 1 ce de tutoriel.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"480\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-8-set-up-target-table.jpg\" alt=\"Choisir la table cible pour l'import du fichier XML des clients\" class=\"wp-image-12777\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-8-set-up-target-table.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-8-set-up-target-table-300x212.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-8-set-up-target-table-678x480.jpg 678w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption>Choisir la table cible pour l&rsquo;import du fichier XML des clients<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-executer-le-package-pour-importer-les-donnees-xml\"><\/span>5. Ex\u00e9cuter le package pour importer les donn\u00e9es XML<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, ex\u00e9cuter le package et v\u00e9rifier que les donn\u00e9es sont bien ins\u00e9r\u00e9es sans erreur dans la table avec une requ\u00eate SQL depuis SSMS.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"540\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-9-execute-file-import.jpg\" alt=\"Ex\u00e9cuter le package SSIS et importer le fichier XML dans la base SQL Server\" class=\"wp-image-12783\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-9-execute-file-import.jpg 580w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-import-xml-file-9-execute-file-import-300x279.jpg 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><figcaption>Ex\u00e9cuter le package SSIS et importer le fichier XML dans la base SQL Server<\/figcaption><\/figure><\/div>\n\n\n<p>Requ\u00eate SQL pour v\u00e9rifier les donn\u00e9es import\u00e9es.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT * FROM [dbo].[Customers];\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-conclusion-sur-limport-de-donnees-au-format-xml-avec-ssis\"><\/span>6. Conclusion sur l&rsquo;import de donn\u00e9es au format XML avec SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Le composant XML Source SSIS est ergonomique, notamment avec l&rsquo;option de g\u00e9n\u00e9ration automatique du sch\u00e9ma XSD directement depuis le fichier XML fourni. Toutefois, pour travailler en contr\u00f4le et \u00e9viter les warnings et les troncations, faire des ajustements manuels, notamment sur la longueur des champs textes.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Autres tutoriels sur l&rsquo;int\u00e9gration de donn\u00e9es avec SSIS<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/expert-only.com\/ssis\/importer-un-fichier-texte-avec-ssis\/\">Importer un fichier CSV avec SSIS<\/a><\/li><li><a href=\"https:\/\/expert-only.com\/ssis\/importer-un-fichier-excel-avec-ssis\/\">Importer un fichier Excel avec SSIS<\/a><\/li><li><a href=\"https:\/\/expert-only.com\/ssis\/charger-plusieurs-fichiers-plats-avec-ssis\/\">Comment importer plusieurs fichiers textes avec SSIS<\/a><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"IXZbisT1n2\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-texte-avec-ssis\/\">Importer un Fichier CSV dans une Table avec SSIS<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Importer un Fichier CSV dans une Table avec SSIS\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-texte-avec-ssis\/embed\/#?secret=JsTjUmaoCz#?secret=IXZbisT1n2\" data-secret=\"IXZbisT1n2\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Importer un fichier au format XML dans une table SQL Server avec un package SSIS. Pour importer un fichier au format XML, il est n\u00e9cessaire de fournir le sch\u00e9ma au format XSD qui repr\u00e9sente la structure du fichier. Dans <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\" title=\"Importer un fichier XML dans une table avec SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-12697","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importer un fichier XML dans une table avec SSIS - MS BI<\/title>\n<meta name=\"description\" content=\"Pour importer un fichier au format XML dans une table SQL avec un package SSIS, utiliser le composant XML Source et une connexion OLE DB.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importer un fichier XML dans une table avec SSIS\" \/>\n<meta property=\"og:description\" content=\"Pour importer un fichier au format XML dans une table SQL avec un package SSIS, utiliser le composant XML Source et une connexion OLE DB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-13T04:29:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-19T16:40:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Importer un fichier XML dans une table avec SSIS\",\"datePublished\":\"2022-10-13T04:29:04+00:00\",\"dateModified\":\"2022-10-19T16:40:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\"},\"wordCount\":868,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\",\"name\":\"Importer un fichier XML dans une table avec SSIS - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"datePublished\":\"2022-10-13T04:29:04+00:00\",\"dateModified\":\"2022-10-19T16:40:41+00:00\",\"description\":\"Pour importer un fichier au format XML dans une table SQL avec un package SSIS, utiliser le composant XML Source et une connexion OLE DB.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importer un fichier XML dans une table avec SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Importer un fichier XML dans une table avec SSIS - MS BI","description":"Pour importer un fichier au format XML dans une table SQL avec un package SSIS, utiliser le composant XML Source et une connexion OLE DB.","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:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Importer un fichier XML dans une table avec SSIS","og_description":"Pour importer un fichier au format XML dans une table SQL avec un package SSIS, utiliser le composant XML Source et une connexion OLE DB.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-10-13T04:29:04+00:00","article_modified_time":"2022-10-19T16:40:41+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Importer un fichier XML dans une table avec SSIS","datePublished":"2022-10-13T04:29:04+00:00","dateModified":"2022-10-19T16:40:41+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/"},"wordCount":868,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/","name":"Importer un fichier XML dans une table avec SSIS - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","datePublished":"2022-10-13T04:29:04+00:00","dateModified":"2022-10-19T16:40:41+00:00","description":"Pour importer un fichier au format XML dans une table SQL avec un package SSIS, utiliser le composant XML Source et une connexion OLE DB.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-xml-avec-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Importer un fichier XML dans une table avec SSIS"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/12697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=12697"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/12697\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10269"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=12697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=12697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=12697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}