{"id":13931,"date":"2023-04-17T06:54:00","date_gmt":"2023-04-17T04:54:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=13931"},"modified":"2023-05-12T10:54:17","modified_gmt":"2023-05-12T08:54:17","slug":"colonnes-en-lignes-avec-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/","title":{"rendered":"Transformer les colonnes en lignes avec SSIS UNPIVOT"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\" id=\"h-transformer-les-colonnes-d-une-table-sql-server-en-lignes-avec-le-composant-de-transformation-ssis-unpivot\"><strong><em>Transformer les colonnes d&rsquo;une table SQL Server en lignes avec le composant de transformation SSIS Unpivot. <\/em><\/strong><\/h4>\n\n\n\n<p>Pour transformer les colonnes en lignes avec le composant SSIS Unpivot, il n&rsquo;est pas n\u00e9cessaire de maitriser l&rsquo;op\u00e9rateur T-SQL UNPIVOT. En effet, il est plus pratique d&rsquo;\u00e9crire une requ\u00eate de s\u00e9lection sur des donn\u00e9es stock\u00e9es de mani\u00e8re verticale plut\u00f4t qu&rsquo;horizontale. Voici donc comment transformer des colonnes en lignes avec le composant SSIS Unpivot. Pour g\u00e9rer les donn\u00e9es d&rsquo;une table SQL avec de la flexibilit\u00e9, il est donc conseill\u00e9 de stocker les donn\u00e9es dans des lignes plut\u00f4t que dans les nom de colonnes.<\/p>\n\n\n\n<p>Ce dernier cas rend la structure de la base de donn\u00e9e moins facile \u00e0 g\u00e9rer. M\u00eame si au niveau espace disque et performance, sur des donn\u00e9es mois par mois, stocker 12 fois moins de lignes peut \u00eatre utile sur des projets SQL.<\/p>\n\n\n\n<p>Tout d&rsquo;abord, le but de ce tutoriel est de transformer des donn\u00e9es mensuelles stock\u00e9es en colonnes vers une table en ligne. La table source a donc 12 colonnes de donn\u00e9es, soit une pour chaque mois de l&rsquo;ann\u00e9e. La table cible elle se compose de deux colonnes distinctes, soit la colonne pour stocker le nom du mois et une colonne pour stocker le montant des ventes.<\/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\/colonnes-en-lignes-avec-ssis\/#1-creer-la-table-source-avec-les-colonnes-a-pivoter-en-lignes\" >1. Cr\u00e9er la table source avec les colonnes \u00e0 pivoter en lignes<\/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\/colonnes-en-lignes-avec-ssis\/#2-inserer-les-donnees-de-ventes-mensuelles-en-colonnes\" >2. Ins\u00e9rer les donn\u00e9es de ventes mensuelles en colonnes<\/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\/colonnes-en-lignes-avec-ssis\/#3-creer-la-table-cible-pour-stocker-les-ventes-en-lignes\" >3. Cr\u00e9er la table cible pour stocker les ventes en lignes<\/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\/colonnes-en-lignes-avec-ssis\/#4-ajouter-les-composants-ssis-ole-db-et-ssis-unpivot-et-configurer-la-connexion\" >4. Ajouter les composants SSIS OLE DB et SSIS UNPIVOT et configurer la connexion<\/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\/colonnes-en-lignes-avec-ssis\/#5-configurer-la-table-source-et-les-colonnes-a-pivoter-avec-ssis\" >5. Configurer la table source et les colonnes \u00e0 pivoter avec SSIS<\/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\/colonnes-en-lignes-avec-ssis\/#6-configurer-le-composant-ssis-unpivot-pour-transformer-les-colonnes-en-lignes\" >6. Configurer le composant SSIS UNPIVOT pour transformer les colonnes en lignes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#7-gerer-le-warning-de-troncation-affiche-par-ssis\" >7. G\u00e9rer le warning de troncation affich\u00e9 par SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#8-parametrer-la-table-cible-avec-la-structure-en-lignes\" >8. Param\u00e9trer la table cible avec la structure en lignes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#9-executer-le-package-ssis-pour-transposer-les-colonnes-en-lignes\" >9. Ex\u00e9cuter le package SSIS pour transposer les colonnes en lignes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#10-comparer-les-colonnes-sources-avec-les-lignes-cibles-depuis-ssms\" >10. Comparer les colonnes sources avec les lignes cibles depuis SSMS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-creer-la-table-source-avec-les-colonnes-a-pivoter-en-lignes\"><\/span>1. Cr\u00e9er la table source avec les colonnes \u00e0 pivoter en lignes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Commencer par cr\u00e9er le jeu de donn\u00e9es pour avoir tous les \u00e9l\u00e9ments en main et comprendre cet exemple avant de l&rsquo;adapter \u00e9ventuellement \u00e0 un cas plus concret. L&rsquo;objectif est de fournir tout le mat\u00e9riel sur ce tutoriel pour se concentrer sur le composant Unpivot et son fonctionnement.<\/p>\n\n\n\n<p>Depuis une connexion SSMS, ex\u00e9cuter le code SQL suivant, qui est de type <a href=\"https:\/\/www.ibm.com\/docs\/fr\/rational-soft-arch\/9.6.1?topic=scripts-generating-ddl\" target=\"_blank\" rel=\"noreferrer noopener\">LDD<\/a> (Langage de D\u00e9finition de Donn\u00e9es). Il permet ainsi de cr\u00e9er la table <em>dbo.Sales_Monthly_In_Columns<\/em> avec une colonne de donn\u00e9es par mois et une ligne par ann\u00e9e.<\/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=\"\">CREATE TABLE [dbo].[Sales_Monthly_In_Columns]\n(\n  [CustomerID] int NOT NULL,\n  [YearID]     nvarchar(20) NOT NULL,\n  [January]    numeric(10,2)  NULL,\n  [February]   numeric(10,2)  NULL,\n  [March]      numeric(10,2)  NULL,\n  [April]      numeric(10,2)  NULL,\n  [May]        numeric(10,2)  NULL,\n  [June]       numeric(10,2)  NULL,\n  [July]       numeric(10,2)  NULL,\n  [August]     numeric(10,2)  NULL,\n  [September]  numeric(10,2)  NULL,\n  [October]    numeric(10,2)  NULL,\n  [November]   numeric(10,2)  NULL,\n  [December]   numeric(10,2)  NULL\n  CONSTRAINT [SalesMonthlyColumnsPK] \n    PRIMARY KEY CLUSTERED (\n      [CustomerID], [YearID] ASC\n    )\n);\nGO<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-inserer-les-donnees-de-ventes-mensuelles-en-colonnes\"><\/span>2. Ins\u00e9rer les donn\u00e9es de ventes mensuelles en colonnes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ins\u00e9rer ensuite le jeu de donn\u00e9es avec les ventes pour les ann\u00e9es 2021 et 2022. Les donn\u00e9es concernent 8 clients diff\u00e9rents, identifi\u00e9s de mani\u00e8re unique par le num\u00e9ro de client, <em>CustomerID<\/em>.<\/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=\"\">INSERT [dbo].[Sales_Monthly_In_Columns] VALUES (1, N'2021', 221.80, 2658.80, 2485.00, 6302.80, 7605.60, 5288.50, 3335.20, 5216.40, 4372.20, 9815.60, 5479.00, 9212.10 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (1, N'2022', 7575.90, 6662.60, 1464.60, 7011.10, 3978.30, 4101.10, 5964.80, 2619.60, 4482.00, 3874.00, 3171.80, 1610.70 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (2, N'2021', 6263.30, 1952.50, 9110.00, 5433.30, 1177.90, 9418.80, 8657.90, 5264.80, 595.80, 6332.50, 3268.50, 3413.50 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (2, N'2022', 2969.90, 3022.70, 1626.10, 9396.30, 8723.30, 9784.80, 9084.10, 3366.40, 8784.50, 1313.50, 7135.00, 8379.10 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (3, N'2021', 2618.90, 5898.70, 7929.10, 5614.40, 7561.80, 5545.80, 2666.50, 2229.70, 1500.50, 6051.40, 1992.20, 1060.80 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (3, N'2022', 2433.10, 8977.80, 9414.60, 4195.10, 6623.20, 1783.40, 1480.30, 4175.00, 2497.20, 6332.10, 6839.20, 145.50 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (4, N'2021', 7170.40, 3507.00, 9154.70, 4465.00, 1109.30, 1905.70, 7980.70, 9227.50, 2166.00, 2988.30, 6353.80, 9448.70 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (4, N'2022', 3287.60, 1805.70, 2068.20, 8353.40, 1378.70, 4689.10, 4720.00, 5643.60, 2722.50, 5539.00, 5494.60, 1790.60 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (5, N'2021', 3336.20, 7451.40, 1656.60, 978.30, 8794.60, 7568.30, 3547.80, 8382.20, 3068.10, 7882.30, 5726.60, 9693.10 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (5, N'2022', 1365.70, 3680.60, 8256.40, 5379.20, 1075.50, 2852.70, 4520.80, 7253.10, 3285.60, 705.10, 2134.60, 7437.00 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (6, N'2021', 1421.30, 2552.40, 174.20, 9158.00, 8138.50, 8458.30, 6548.90, 4805.80, 3026.50, 8127.40, 6626.40, 1035.70 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (6, N'2022', 2253.40, 1107.30, 9349.30, 3751.80, 9320.90, 2485.60, 435.30, 6358.10, 733.10, 1015.90, 7780.70, 6232.40 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (7, N'2021', 3971.30, 1538.20, 7727.50, 4494.10, 6314.70, 640.10, 6070.30, 5926.00, 7013.10, 2119.20, 3188.20, 4474.20 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (7, N'2022', 7082.40, 3010.10, 8716.00, 8493.50, 1782.80, 3023.20, 3897.60, 1752.80, 5952.30, 8430.40, 6643.10, 6276.10 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (8, N'2021', 7279.40, 4494.40, 7045.30, 4253.30, 6702.40, 9017.20, 810.00, 7891.80, 663.10, 5771.40, 3190.10, 6130.00 );\nINSERT [dbo].[Sales_Monthly_In_Columns] VALUES (8, N'2022', 8253.70, 7844.60, 3655.80, 1046.10, 290.10, 5580.40, 3572.70, 9926.10, 6213.90, 7622.80, 3414.60, 4581.40 );\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-creer-la-table-cible-pour-stocker-les-ventes-en-lignes\"><\/span>3. Cr\u00e9er la table cible pour stocker les ventes en lignes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cr\u00e9er maintenant la deuxi\u00e8me table SQL, avec cette fois les mois en lignes. Les colonnes de regroupement, c&rsquo;est \u00e0 dire le num\u00e9ro de client et l&rsquo;ann\u00e9e sont toujours pr\u00e9sentes. <\/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=\"\">CREATE TABLE [dbo].[Sales_Monthly_In_Lines]\n(\n  [CustomerID]  int NOT NULL,\n  [YearID]      nvarchar(20) NOT NULL,\n  [MonthName]   nvarchar(10) NOT NULL,\n  [SalesAmount] numeric(10,2)  NULL\n  CONSTRAINT [SalesMonthlyLinesPK] \n    PRIMARY KEY CLUSTERED (\n      [CustomerID], [YearID], [MonthName] ASC\n    )\n);\nGO<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-ajouter-les-composants-ssis-ole-db-et-ssis-unpivot-et-configurer-la-connexion\"><\/span>4. Ajouter les composants SSIS OLE DB et SSIS UNPIVOT et configurer la connexion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici maintenant les \u00e9tapes clefs de ce cours pour transformer les colonnes en lignes avec SSIS Unpivot. C&rsquo;est \u00e0 dire la configuration du flux de donn\u00e9es. Ouvrir un package SSIS existant ou <a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">cr\u00e9er un nouveau projet et un package avec Visual Studio<\/a>. Au pr\u00e9alable, <a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-connexion-base-sql-server-ssis\/\">cr\u00e9er une connexion \u00e0 la base de donn\u00e9es SQL Server<\/a>, n\u00e9cessaire pour ex\u00e9cuter le package. Ajouter ensuite un flux de donn\u00e9es et y ins\u00e9rer les trois composants utiles.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><em><strong>OLE DB Source<\/strong><\/em> : \u00e0 faire pointer sur la table <em><strong>Sales_Monthly_In_Columns<\/strong><\/em><\/li>\n\n\n\n<li><strong><em>Composant SSIS Unpivot<\/em><\/strong> : \u00e0 param\u00e9trer pour <strong><em>transposer les mois<\/em><\/strong> et leur valeur en lignes<\/li>\n\n\n\n<li><em><strong>OLE DB Destination<\/strong><\/em> : pointer sur la table cible <em><strong>Sales_Monthly_In_Lines<\/strong><\/em> avec la structure en lignes.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-1-add-source-unpivot-target.jpg\" alt=\"Ajouter les composants source, Unpivot et destination pour transformer les colonnes en lignes avec SSIS UNPIVOT\" class=\"wp-image-13956\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-1-add-source-unpivot-target.jpg 680w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-1-add-source-unpivot-target-300x256.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><figcaption class=\"wp-element-caption\"><em>Ajouter les composants Source, Unpivot et Destination au flux de donn\u00e9es SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-configurer-la-table-source-et-les-colonnes-a-pivoter-avec-ssis\"><\/span>5. Configurer la table source et les colonnes \u00e0 pivoter avec SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>S\u00e9lectionner la table avec la structure en colonnes comme source pour le package SSIS.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"380\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-2-source-data-in-columns.jpg\" alt=\"S\u00e9lectionner la table source avec les colonnes \u00e0 transformer en lignes avec SSIS et UNPIVOT\" class=\"wp-image-13970\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-2-source-data-in-columns.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-2-source-data-in-columns-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lectionner la table source avec les colonnes \u00e0 transformer en lignes<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier aussi les colonnes pr\u00e9sentes depuis l&rsquo;onglet <em>Columns<\/em>, les 12 mois sont pr\u00e9sents. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"720\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-3-check-source-columns.jpg\" alt=\"V\u00e9rifier les colonnes sources \u00e0 transposer depuis la source\" class=\"wp-image-13978\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-3-check-source-columns.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-3-check-source-columns-250x300.jpg 250w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">V\u00e9rifier les colonnes sources \u00e0 transposer depuis la source<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-configurer-le-composant-ssis-unpivot-pour-transformer-les-colonnes-en-lignes\"><\/span>6. Configurer le composant SSIS UNPIVOT pour transformer les colonnes en lignes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Suivre ces \u00e9tapes pour configurer le composant SSIS Unpivot pour transposer les colonnes en lignes. <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>S\u00e9lectionner les colonnes d&rsquo;agr\u00e9gations avec l&rsquo;option Pass Through : ici c&rsquo;est <em>CustomerID<\/em> et <em>YearID<\/em>.<\/li>\n\n\n\n<li>Choisir toutes les colonnes \u00e0 transposer : les colonnes des 12 mois de <em>janvier<\/em> \u00e0 <em>d\u00e9cembre<\/em>.<\/li>\n\n\n\n<li>Entrer le nom de la nouvelle colonne o\u00f9 stocker les ventes : <em>SalesAmount<\/em>.<\/li>\n\n\n\n<li>Taper le nom de la colonne pour la clef de pivot, ou stocker le nom des mois : <em>MonthName<\/em>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"945\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-4-configure-unpivot-options.jpg\" alt=\"Configurer le composant SSIS Unpivot pour transformer les colonnes en lignes\" class=\"wp-image-13985\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-4-configure-unpivot-options.jpg 660w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-4-configure-unpivot-options-210x300.jpg 210w\" sizes=\"auto, (max-width: 660px) 100vw, 660px\" \/><figcaption class=\"wp-element-caption\">Configurer le composant SSIS Unpivot pour transformer les colonnes en lignes<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-gerer-le-warning-de-troncation-affiche-par-ssis\"><\/span>7. G\u00e9rer le warning de troncation affich\u00e9 par SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Comme dans beaucoup de composants sources ou de transformation de donn\u00e9es, SQL Server Integration Services assigne aux nouvelles colonnes un type de donn\u00e9es par d\u00e9faut qui est (DT_WSTR,255). Ce qui ainsi provoque ce warning dans le composant cible.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><em><strong>[OLE DB Destination] Warning: Truncation may occur due to inserting data from data flow column \u00ab\u00a0MonthName\u00a0\u00bb with a length of 255 to database column \u00ab\u00a0MonthName\u00a0\u00bb with a length of 10.<\/strong><\/em><\/p>\n\n\n\n<p>En effet, la nouvelle colonne <em>MonthName<\/em> en sortie du bloc Unpivot est de type DT_WSTR avec une longueur de 255, tandis que la colonne dans la table est de type NVARCHAR(10).<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"200\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-5-unpivot-truncation-warning.jpg\" alt=\"Warning SSIS de troncation de donn\u00e9es apr\u00e8s le composant Unpivot\" class=\"wp-image-14005\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-5-unpivot-truncation-warning.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-5-unpivot-truncation-warning-300x83.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\">Warning SSIS de troncation de donn\u00e9es apr\u00e8s le composant Unpivot<\/figcaption><\/figure><\/div>\n\n\n<p>La solution pour g\u00e9rer ce comportement et supprimer l&rsquo;avertissement est donc de changer le type de la colonne en sortie dans l&rsquo;\u00e9diteur avanc\u00e9 du bloc Unpivot SSIS.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Faire d&rsquo;abord un <strong><em>clic-droit<\/em><\/strong> sur le composant Unpivot SSIS et choisir <strong><em>Show Advanced Editor&#8230;<\/em><\/strong> puis choisir <em>Input and Output Properties<\/em>.<\/li>\n\n\n\n<li>Depuis la section <em>Unpivot Output<\/em>, s\u00e9lectionner la colonne <strong><em>MonthName<\/em><\/strong> \u00e0 \u00e9diter.<\/li>\n\n\n\n<li>Changer enfin la longueur de 255 caract\u00e8res \u00e0 <strong><em>10 caract\u00e8res<\/em><\/strong>. <\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"711\" height=\"622\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-6-change-pivot-key-data-length.jpg\" alt=\"Changer la longueur de la colonne de pivot dans l'\u00e9diteur avanc\u00e9 Unpivot SSIS\" class=\"wp-image-14018\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-6-change-pivot-key-data-length.jpg 711w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-6-change-pivot-key-data-length-300x262.jpg 300w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><figcaption class=\"wp-element-caption\">Changer la longueur de la colonne de pivot dans l&rsquo;\u00e9diteur avanc\u00e9 Unpivot SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>Apr\u00e8s cette adaptation de la longueur \u00e0 la table cible, le package peut-\u00eatre ex\u00e9cuter de mani\u00e8re fluide et sans warnings dans <a href=\"https:\/\/expert-only.com\/ssis\/configurer-la-log-ssis\/\">les logs SSIS<\/a> \u00e0 chaque ex\u00e9cution.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8-parametrer-la-table-cible-avec-la-structure-en-lignes\"><\/span>8. Param\u00e9trer la table cible avec la structure en lignes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ouvrir maintenant la destination et choisir la deuxi\u00e8me table avec une structure de donn\u00e9es en lignes.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"380\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-7-target-table-in-lines.jpg\" alt=\"Choisir la table depuis l'\u00e9diteur OLE DB Destination\" class=\"wp-image-14059\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-7-target-table-in-lines.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-7-target-table-in-lines-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Choisir la table depuis l&rsquo;\u00e9diteur OLE DB Destination<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier le mapping, et mapper au besoin les colonnes en se basant sur le nom des colonnes.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ouvrir l&rsquo;\u00e9diteur OLE DB et faire un <strong><em>clic-droit<\/em><\/strong><\/li>\n\n\n\n<li>S\u00e9lectionner alors <strong><em>Map Items by Matching Names<\/em><\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"520\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-8-check-target-mapping.jpg\" alt=\"V\u00e9rifier le mapping des colonnes SSIS depuis l'\u00e9diteur OLE DB\" class=\"wp-image-14055\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-8-check-target-mapping.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-8-check-target-mapping-300x260.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">V\u00e9rifier le mapping des colonnes SSIS depuis l&rsquo;\u00e9diteur OLE DB<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"9-executer-le-package-ssis-pour-transposer-les-colonnes-en-lignes\"><\/span>9. Ex\u00e9cuter le package SSIS pour transposer les colonnes en lignes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter enfin le package pour pivoter les 16 lignes sources en 16*12 lignes, soit 192 lignes au total.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"480\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-9-execute-package.jpg\" alt=\"Transformer des donn\u00e9es structur\u00e9es en colonnes vers des lignes avec SSIS\" class=\"wp-image-14078\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-9-execute-package.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-9-execute-package-300x240.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Transformer des donn\u00e9es structur\u00e9es en colonnes vers des lignes avec SSIS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"10-comparer-les-colonnes-sources-avec-les-lignes-cibles-depuis-ssms\"><\/span>10. Comparer les colonnes sources avec les lignes cibles depuis SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour v\u00e9rifier le bon fonctionnement du package SSIS, se connecter d&rsquo;abord \u00e0 SSMS et ex\u00e9cuter ces deux requ\u00eates SQL.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Une premi\u00e8re requ\u00eate SQL pour <em><strong>lire la table source en colonnes<\/strong><\/em>.<\/li>\n\n\n\n<li>Une deuxi\u00e8me requ\u00eate SQL pour <strong><em>lire la table transform\u00e9e en lignes<\/em><\/strong>.<\/li>\n<\/ol>\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].[Sales_Monthly_In_Columns];\n\nselect\t*\nfrom\t[dbo].[Sales_Monthly_In_Lines]\norder by YearID, CustomerID, MONTH(MonthName + ' 01, 1900');<\/pre>\n\n\n\n<p>Enfin, les montants de la premi\u00e8re table sont pr\u00e9sents dans la deuxi\u00e8me avec une structure en lignes.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"760\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-10-check-data-in-lines-ssms.jpg\" alt=\"Comparaison des colonnes et des lignes pivot\u00e9es par SSIS\" class=\"wp-image-14092\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-10-check-data-in-lines-ssms.jpg 860w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-10-check-data-in-lines-ssms-300x265.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-unpivot-data-10-check-data-in-lines-ssms-768x679.jpg 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><figcaption class=\"wp-element-caption\">Comparaison des colonnes et des lignes pivot\u00e9es par SSIS<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Conclusion sur la transformation SSIS Unpivot<\/h3>\n\n\n\n<p>Transformer les colonnes en lignes avec SSIS et la transformation UNPIVOT se fait donc de mani\u00e8re simple et guid\u00e9e, voire presque automatis\u00e9e. Il suffit donc de g\u00e9rer \u00e9ventuellement les longueurs des colonnes des clefs de PIVOT. Un pr\u00e9requis tout de m\u00eame est de comprendre comment fonctionne l&rsquo;op\u00e9rateur UNPIVOT classique en T-SQL.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Autres techniques pour pivoter des donn\u00e9es avec Microsoft<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/pivot-sql-server\/\"><strong>Pivoter des donn\u00e9es avec une requ\u00eate SQL Server<\/strong><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/astuces-excel\/pivoter-tableau-excel\/\"><strong>Pivoter des donn\u00e9es avec Excel<\/strong><\/a><\/li>\n<\/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=\"tkqymACP9k\"><a href=\"https:\/\/expert-only.com\/fr\/tutoriels-ssis\/\">Tutoriels SSIS pour d\u00e9butants<\/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\u00a0Tutoriels SSIS pour d\u00e9butants\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/tutoriels-ssis\/embed\/#?secret=Dw7OtAzE5D#?secret=tkqymACP9k\" data-secret=\"tkqymACP9k\" 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>Transformer les colonnes d&rsquo;une table SQL Server en lignes avec le composant de transformation SSIS Unpivot. Pour transformer les colonnes en lignes avec le composant SSIS Unpivot, il n&rsquo;est pas n\u00e9cessaire de maitriser l&rsquo;op\u00e9rateur T-SQL UNPIVOT. En effet, il <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\" title=\"Transformer les colonnes en lignes avec SSIS UNPIVOT\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10662,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-13931","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>Transformer les colonnes en lignes avec SSIS UNPIVOT - MS BI<\/title>\n<meta name=\"description\" content=\"Transformer les colonnes d&#039;une table SQL Server en lignes avec un package et la transformation SSIS UNPIVOT, \u00e9quivalente \u00e0 l&#039;op\u00e9rateur T-SQL.\" \/>\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\/colonnes-en-lignes-avec-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transformer les colonnes en lignes avec SSIS UNPIVOT\" \/>\n<meta property=\"og:description\" content=\"Transformer les colonnes d&#039;une table SQL Server en lignes avec un package et la transformation SSIS UNPIVOT, \u00e9quivalente \u00e0 l&#039;op\u00e9rateur T-SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-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=\"2023-04-17T04:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-12T08:54:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_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=\"9 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\/colonnes-en-lignes-avec-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Transformer les colonnes en lignes avec SSIS UNPIVOT\",\"datePublished\":\"2023-04-17T04:54:00+00:00\",\"dateModified\":\"2023-05-12T08:54:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\"},\"wordCount\":1295,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\",\"name\":\"Transformer les colonnes en lignes avec SSIS UNPIVOT - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"datePublished\":\"2023-04-17T04:54:00+00:00\",\"dateModified\":\"2023-05-12T08:54:17+00:00\",\"description\":\"Transformer les colonnes d'une table SQL Server en lignes avec un package et la transformation SSIS UNPIVOT, \u00e9quivalente \u00e0 l'op\u00e9rateur T-SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transformer les colonnes en lignes avec SSIS UNPIVOT\"}]},{\"@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":"Transformer les colonnes en lignes avec SSIS UNPIVOT - MS BI","description":"Transformer les colonnes d'une table SQL Server en lignes avec un package et la transformation SSIS UNPIVOT, \u00e9quivalente \u00e0 l'op\u00e9rateur T-SQL.","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\/colonnes-en-lignes-avec-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Transformer les colonnes en lignes avec SSIS UNPIVOT","og_description":"Transformer les colonnes d'une table SQL Server en lignes avec un package et la transformation SSIS UNPIVOT, \u00e9quivalente \u00e0 l'op\u00e9rateur T-SQL.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-04-17T04:54:00+00:00","article_modified_time":"2023-05-12T08:54:17+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_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":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Transformer les colonnes en lignes avec SSIS UNPIVOT","datePublished":"2023-04-17T04:54:00+00:00","dateModified":"2023-05-12T08:54:17+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/"},"wordCount":1295,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/","name":"Transformer les colonnes en lignes avec SSIS UNPIVOT - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","datePublished":"2023-04-17T04:54:00+00:00","dateModified":"2023-05-12T08:54:17+00:00","description":"Transformer les colonnes d'une table SQL Server en lignes avec un package et la transformation SSIS UNPIVOT, \u00e9quivalente \u00e0 l'op\u00e9rateur T-SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/gears-B88132008B1_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/colonnes-en-lignes-avec-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Transformer les colonnes en lignes avec SSIS UNPIVOT"}]},{"@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\/13931","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=13931"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/13931\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10662"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=13931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=13931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=13931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}