{"id":13644,"date":"2022-10-19T06:46:00","date_gmt":"2022-10-19T04:46:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=13644"},"modified":"2022-12-19T16:51:49","modified_gmt":"2022-12-19T15:51:49","slug":"agreger-des-donnees-avec-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/","title":{"rendered":"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-agreger-et-faire-la-somme-de-donnees-pour-realiser-l-equivalent-du-group-by-en-sql-avec-le-composant-ssis-aggregate\"><strong><em>Agr\u00e9ger et faire la somme de donn\u00e9es pour r\u00e9aliser l&rsquo;\u00e9quivalent du GROUP BY en SQL avec le composant SSIS Aggregate.<\/em><\/strong><\/h4>\n\n\n\n<p>Dans un projet ETL avec SSIS, il est courant de calculer des agr\u00e9gations de donn\u00e9es depuis une table SQL Server vers \u00e0 un niveau sup\u00e9rieur, comme les magasins de donn\u00e9es. C&rsquo;est \u00e0 dire, en pratique calculer la somme de montants. Pour cela, deux solutions possibles, \u00e9crire une requ\u00eate SQL classique de type Group By ou utiliser le composant SSIS Aggregate. Ce tutoriel explique pas \u00e0 pas comment utiliser le composant SSIS et regrouper des donn\u00e9es sans \u00e9crire de requ\u00eate SQL.<\/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\/agreger-des-donnees-avec-ssis\/#1-preparer-les-tables-et-les-donnees-avec-sql-server\" >1. Pr\u00e9parer les tables et les donn\u00e9es avec SQL Server<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#11-creer-la-table-des-ventes-avec-le-script-sql\" >1.1 Cr\u00e9er la table des ventes avec le script SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#12-creer-la-table-des-ventes-groupees-avec-le-script-sql\" >1.2 Cr\u00e9er la table des ventes group\u00e9es avec le script SQL<\/a><\/li><\/ul><\/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\/agreger-des-donnees-avec-ssis\/#2-creer-le-flux-de-donnees-ssis-pour-agreger-les-donnees\" >2. Cr\u00e9er le flux de donn\u00e9es SSIS pour agr\u00e9ger les donn\u00e9es<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#21-ajouter-tous-les-composant-ssis-au-flux-de-donnees\" >2.1 Ajouter tous les composant SSIS au flux de donn\u00e9es<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#22-configurer-la-table-source-avec-ssis\" >2.2 Configurer la table source avec SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#23-parametrer-le-group-by-dans-le-composant-dagregation-ssis\" >2.3 Param\u00e9trer le GROUP BY dans le composant d&rsquo;agr\u00e9gation SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#24-configurer-la-table-cible\" >2.4 Configurer la table cible<\/a><\/li><\/ul><\/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\/agreger-des-donnees-avec-ssis\/#3-executer-le-package-ssis-et-verifier-les-donnees-agregees\" >3. Ex\u00e9cuter le package SSIS et v\u00e9rifier les donn\u00e9es agr\u00e9g\u00e9es<\/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\/agreger-des-donnees-avec-ssis\/#4-conclusion-sur-la-transformation-ssis-aggregate\" >4. Conclusion sur la transformation SSIS Aggregate<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-preparer-les-tables-et-les-donnees-avec-sql-server\"><\/span>1. Pr\u00e9parer les tables et les donn\u00e9es avec SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;objectif de ce tutoriel est de lire puis agr\u00e9ger des donn\u00e9es depuis le niveau de la table des ventes, <strong><em>dbo.Sales<\/em><\/strong>: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Client<\/li>\n\n\n\n<li>Mois<\/li>\n\n\n\n<li>Ann\u00e9e<\/li>\n\n\n\n<li>Produit<\/li>\n<\/ul>\n\n\n\n<p>Vers un niveau plus haut et les stocker dans la table agr\u00e9g\u00e9e des ventes, <strong><em>dbo.Sales_Grouped<\/em><\/strong>, c&rsquo;est \u00e0 dire: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Client<\/li>\n\n\n\n<li>Ann\u00e9e<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-creer-la-table-des-ventes-avec-le-script-sql\"><\/span>1.1 Cr\u00e9er la table des ventes avec le script SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Se connecter \u00e0 SSMS et ex\u00e9cuter ce script pour cr\u00e9er la table source.<\/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](\n  [CustomerID]  [int] NOT NULL,\n  [MonthID]     [nvarchar](20) NOT NULL,\n  [YearID]      [nvarchar](20) NOT NULL,\n  [Qty]         [numeric](10,2) NOT NULL,\n  [Price]       [numeric](10,2) NOT NULL,\n  [Sales]       [numeric](10,2) NOT NULL,\n  [ProductID]   [int] NOT NULL,\n  [ProductName] [nvarchar](100) NOT NULL,\n  CONSTRAINT [SalesPK] \n    PRIMARY KEY CLUSTERED (\n      [CustomerID], [MonthID], [YearID], [ProductID] ASC\n    )\n);\nGO<\/pre>\n\n\n\n<p>Ins\u00e9rer ensuite les 44 lignes de ventes au niveau fin.<\/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] VALUES (1, N'1', N'2022', 10.00, 879.20, 8792.00, 31, N'Babka');\nINSERT [dbo].[Sales] VALUES (1, N'3', N'2021', 5.00, 312.00, 1560.00, 40, N'Unreal');\nINSERT [dbo].[Sales] VALUES (1, N'6', N'2021', 9.00, 627.00, 5643.00, 27, N'Qrunch');\nINSERT [dbo].[Sales] VALUES (1, N'7', N'2022', 6.00, 621.70, 3730.20, 10, N'Ambrosi');\nINSERT [dbo].[Sales] VALUES (1, N'7', N'2022', 4.00, 653.10, 2612.40, 47, N'Quickick');\nINSERT [dbo].[Sales] VALUES (1, N'9', N'2021', 2.00, 734.90, 1469.80, 47, N'Quickick');\nINSERT [dbo].[Sales] VALUES (2, N'2', N'2021', 9.00, 895.60, 8060.40, 47, N'Quickick');\nINSERT [dbo].[Sales] VALUES (2, N'3', N'2022', 11.00, 51.80, 569.80, 49, N'Menudito');\nINSERT [dbo].[Sales] VALUES (2, N'7', N'2021', 11.00, 112.20, 1234.20, 19, N'Chiavie');\nINSERT [dbo].[Sales] VALUES (2, N'9', N'2022', 7.00, 581.80, 4072.60, 33, N'Jans');\nINSERT [dbo].[Sales] VALUES (3, N'2', N'2022', 4.00, 576.60, 2306.40, 5, N'Amoy');\nINSERT [dbo].[Sales] VALUES (3, N'6', N'2021', 6.00, 551.10, 3306.60, 8, N'Gilda');\nINSERT [dbo].[Sales] VALUES (4, N'0', N'2021', 7.00, 15.40, 107.80, 26, N'Lasco');\nINSERT [dbo].[Sales] VALUES (4, N'1', N'2022', 2.00, 706.60, 1413.20, 27, N'Qrunch');\nINSERT [dbo].[Sales] VALUES (4, N'1', N'2022', 9.00, 491.70, 4425.30, 30, N'Paldo');\nINSERT [dbo].[Sales] VALUES (4, N'3', N'2022', 4.00, 810.20, 3240.80, 22, N'Bourbon');\nINSERT [dbo].[Sales] VALUES (4, N'4', N'2021', 9.00, 648.90, 5840.10, 42, N'Barbacoa');\nINSERT [dbo].[Sales] VALUES (4, N'5', N'2021', 7.00, 284.90, 1994.30, 5, N'Amoy');\nINSERT [dbo].[Sales] VALUES (5, N'11', N'2021', 3.00, 914.90, 2744.70, 45, N'Predue');\nINSERT [dbo].[Sales] VALUES (5, N'11', N'2022', 9.00, 903.80, 8134.20, 44, N'Kemps');\nINSERT [dbo].[Sales] VALUES (5, N'4', N'2022', 10.00, 133.90, 1339.00, 6, N'Haystack');\nINSERT [dbo].[Sales] VALUES (5, N'6', N'2021', 10.00, 940.20, 9402.00, 34, N'Amazin');\nINSERT [dbo].[Sales] VALUES (5, N'7', N'2021', 7.00, 352.90, 2470.30, 32, N'Maverik');\nINSERT [dbo].[Sales] VALUES (5, N'7', N'2022', 3.00, 116.40, 349.20, 7, N'Kalamata');\nINSERT [dbo].[Sales] VALUES (6, N'1', N'2021', 4.00, 283.30, 1133.20, 23, N'Oatsnack');\nINSERT [dbo].[Sales] VALUES (6, N'4', N'2021', 4.00, 604.90, 2419.60, 10, N'Ambrosi');\nINSERT [dbo].[Sales] VALUES (6, N'4', N'2022', 5.00, 184.30, 921.50, 6, N'Haystack');\nINSERT [dbo].[Sales] VALUES (6, N'5', N'2022', 9.00, 464.40, 4179.60, 18, N'Lurpak');\nINSERT [dbo].[Sales] VALUES (6, N'8', N'2021', 6.00, 836.10, 5016.60, 40, N'Unreal');\nINSERT [dbo].[Sales] VALUES (6, N'9', N'2022', 4.00, 254.80, 1019.20, 1, N'Boncora');\nINSERT [dbo].[Sales] VALUES (7, N'0', N'2021', 7.00, 100.90, 706.30, 45, N'Predue');\nINSERT [dbo].[Sales] VALUES (7, N'10', N'2021', 4.00, 161.50, 646.00, 10, N'Ambrosi');\nINSERT [dbo].[Sales] VALUES (7, N'10', N'2022', 7.00, 484.50, 3391.50, 50, N'Armanino');\nINSERT [dbo].[Sales] VALUES (7, N'3', N'2022', 7.00, 748.80, 5241.60, 38, N'Exo');\nINSERT [dbo].[Sales] VALUES (7, N'6', N'2021', 1.00, 623.50, 623.50, 45, N'Predue');\nINSERT [dbo].[Sales] VALUES (7, N'7', N'2021', 6.00, 185.00, 1110.00, 28, N'Basilico');\nINSERT [dbo].[Sales] VALUES (7, N'8', N'2022', 7.00, 625.50, 4378.50, 4, N'Sartori');\nINSERT [dbo].[Sales] VALUES (7, N'8', N'2022', 3.00, 125.40, 376.20, 38, N'Exo');\nINSERT [dbo].[Sales] VALUES (8, N'1', N'2021', 8.00, 949.80, 7598.40, 16, N'Homekist');\nINSERT [dbo].[Sales] VALUES (8, N'10', N'2021', 9.00, 944.30, 8498.70, 41, N'Baked');\nINSERT [dbo].[Sales] VALUES (8, N'10', N'2022', 7.00, 578.10, 4046.70, 2, N'Master');\nINSERT [dbo].[Sales] VALUES (8, N'12', N'2022', 3.00, 309.20, 927.60, 42, N'Barbacoa');\nINSERT [dbo].[Sales] VALUES (8, N'2', N'2022', 4.00, 417.80, 1671.20, 25, N'Scrapple');\nINSERT [dbo].[Sales] VALUES (8, N'4', N'2021', 7.00, 509.20, 3564.40, 4, N'Sartori');<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12-creer-la-table-des-ventes-groupees-avec-le-script-sql\"><\/span>1.2 Cr\u00e9er la table des ventes group\u00e9es avec le script SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Cr\u00e9er ensuite la table des ventes regroup\u00e9es par ann\u00e9e et client. Cette table sera charg\u00e9e par le package SSIS.<\/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_Grouped](\n  [CustomerID] [int] NOT NULL,\n  [YearID]     [nvarchar](20) NOT NULL,\n  [Sales]      [numeric](10,2) NOT NULL,\n  CONSTRAINT [SalesGroupedPK] \n    PRIMARY KEY CLUSTERED (\n      [CustomerID], [YearID] ASC\n    )\n);\nGO<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-creer-le-flux-de-donnees-ssis-pour-agreger-les-donnees\"><\/span>2. Cr\u00e9er le flux de donn\u00e9es SSIS pour agr\u00e9ger les donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Configurer maintenant le flux de donn\u00e9es avec les composants n\u00e9cessaires. Les pr\u00e9requis sont d&rsquo;avoir cr\u00e9\u00e9s avec Visual Studio: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">Un projet et un package SSIS<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/creer-connexion-base-sql-server-ssis\/\">Une connexion \u00e0 une base de donn\u00e9es SQL Server<\/a> avec le gestionnaire de connexions SSIS<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21-ajouter-tous-les-composant-ssis-au-flux-de-donnees\"><\/span>2.1 Ajouter tous les composant SSIS au flux de donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Depuis un package SSIS, ajouter un flux de donn\u00e9es. Ajouter ensuite trois composants: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Une source <strong><em>OLE DB<\/em><\/strong><\/li>\n\n\n\n<li>Une transformation SSIS <strong><em>Aggregate<\/em><\/strong><\/li>\n\n\n\n<li>Un composant <strong><em>OLE DB Destination<\/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=\"720\" height=\"440\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-1-add-source-aggregate-target.jpg\" alt=\"Ajouter les composants Source, Aggregate et Destination au flux de donn\u00e9es SSIS\" class=\"wp-image-13665\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-1-add-source-aggregate-target.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-1-add-source-aggregate-target-300x183.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\">Ajouter les composants Source, Aggregate et Destination au flux de donn\u00e9es SSIS<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22-configurer-la-table-source-avec-ssis\"><\/span>2.2 Configurer la table source avec SSIS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Ouvrir le composant OLE DB Source et s\u00e9lectionner la table des ventes cr\u00e9\u00e9 et aliment\u00e9e \u00e0 l&rsquo;\u00e9tape 1.1.<\/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-group-by-sum-2-setup-ole-db-source.jpg\" alt=\"Choisir la table source \u00e0 agr\u00e9ger avec le composant SSIS\" class=\"wp-image-13675\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-2-setup-ole-db-source.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-2-setup-ole-db-source-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Choisir la table source \u00e0 agr\u00e9ger avec le composant SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier depuis l&rsquo;onglet Colonnes (Columns) que les colonnes de la table sont mapp\u00e9es correctement.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-3-check-source-mapping.jpg\" alt=\"V\u00e9rifier le mapping des colonnes sources depuis le package SSIS\" class=\"wp-image-13684\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-3-check-source-mapping.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-3-check-source-mapping-300x290.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">V\u00e9rifier le mapping des colonnes sources depuis le package SSIS<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"23-parametrer-le-group-by-dans-le-composant-dagregation-ssis\"><\/span>2.3 Param\u00e9trer le GROUP BY dans le composant d&rsquo;agr\u00e9gation SSIS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Relier le composant <strong><em>OLE DB Source<\/em><\/strong> au composant <strong><em>Aggregate<\/em><\/strong> SSIS. Ouvrir maintenant la transformation et s\u00e9lectionner les colonnes suivantes: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>CustomerID<\/strong><em> <\/em>: avec une op\u00e9ration <strong><em>Group By<\/em><\/strong>.<\/li>\n\n\n\n<li><strong>YearID<\/strong> : avec une op\u00e9ration <strong><em>Group By<\/em><\/strong>.<\/li>\n\n\n\n<li><strong>Sales<\/strong> : avec une op\u00e9ration <strong><em>Sum<\/em><\/strong> pour calculer la somme des ventes en sortie du composant.<\/li>\n<\/ol>\n\n\n\n<p>Le composant SSIS d\u00e9tecte les types de donn\u00e9es et par d\u00e9faut ne propose d&rsquo;<a href=\"https:\/\/fr.wikipedia.org\/wiki\/Fonction_d'agr\u00e9gation\" target=\"_blank\" rel=\"noreferrer noopener\">op\u00e9rations d&rsquo;agr\u00e9gations<\/a> que pour les colonnes num\u00e9riques.<\/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-group-by-sum-4-setup-aggregate-transformation.jpg\" alt=\"Configurer le composant d'agr\u00e9gation SSIS pour agr\u00e9ger les donn\u00e9es et calculer la somme\" class=\"wp-image-13689\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-4-setup-aggregate-transformation.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-4-setup-aggregate-transformation-250x300.jpg 250w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Configurer le composant d&rsquo;agr\u00e9gation SSIS pour agr\u00e9ger les donn\u00e9es et calculer la somme<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"24-configurer-la-table-cible\"><\/span>2.4 Configurer la table cible<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Relier maintenant le composant Aggregate avec la table cible. Choisir simplement la table <strong><em>dbo.Sales_Grouped<\/em><\/strong>. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-5-set-up-detination-table.jpg\" alt=\"Choisir la table cible pour stocker les donn\u00e9es \u00e0 agr\u00e9ger avec le package SSIS\" class=\"wp-image-13699\" width=\"600\" height=\"380\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-5-set-up-detination-table.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-5-set-up-detination-table-300x190.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Choisir la table SQL cible pour stocker les donn\u00e9es \u00e0 agr\u00e9ger avec le package SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>V\u00e9rifier aussi le mapping depuis l&rsquo;onglet <em>Mappings<\/em>.<\/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-group-by-sum-6-check-target-mapping.jpg\" alt=\"V\u00e9rifier le mapping des 3 colonnes sources avec la cible\" class=\"wp-image-13705\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-6-check-target-mapping.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-6-check-target-mapping-300x240.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">V\u00e9rifier le mapping des 3 colonnes sources avec la cible<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-executer-le-package-ssis-et-verifier-les-donnees-agregees\"><\/span>3. Ex\u00e9cuter le package SSIS et v\u00e9rifier les donn\u00e9es agr\u00e9g\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter enfin le packager SSIS pour grouper les donn\u00e9es de ventes \u00e0 un niveau annuel et les stocker dans la deuxi\u00e8me table. Le package lit 44 lignes sources et regroupe les donn\u00e9es de la table en 16 lignes. <\/p>\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-group-by-sum-7-execute-aggregation.jpg\" alt=\"Ex\u00e9cuter le package pour agr\u00e9ger les 44 lignes initiales en 16 lignes calcul\u00e9es\" class=\"wp-image-13711\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-7-execute-aggregation.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-7-execute-aggregation-300x260.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Ex\u00e9cuter le package pour agr\u00e9ger les 44 lignes initiales en 16 lignes calcul\u00e9es<\/figcaption><\/figure><\/div>\n\n\n<p>Pour contr\u00f4ler les donn\u00e9es, deux options, la premi\u00e8re est d&rsquo;utiliser la visionneuse de donn\u00e9es SSIS directement depuis le composant OLE DB Destination, comme ceci: <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"640\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-8-check-aggregated-data.jpg\" alt=\"R\u00e9sultat avec les donn\u00e9es de la table agr\u00e9g\u00e9es par clients et par ann\u00e9es\" class=\"wp-image-13717\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-8-check-aggregated-data.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-8-check-aggregated-data-281x300.jpg 281w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">R\u00e9sultat avec les donn\u00e9es de la table agr\u00e9g\u00e9es par clients et par ann\u00e9es<\/figcaption><\/figure><\/div>\n\n\n<p>La deuxi\u00e8me option est d&rsquo;ex\u00e9cuter directement depuis SSMS une requ\u00eate SQL pour v\u00e9rifier que les donn\u00e9es de la table sont conformes. Ex\u00e9cuter donc cette requ\u00eate SQL avec la fonction GROUP BY qui est l&rsquo;\u00e9quivalent des op\u00e9rations du package SSIS. <\/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 \n  [CustomerID],\n  [YearID],\n  SUM([Sales]) AS [Sales]\nFROM [dbo].[Sales]\nGROUP BY   \n  [CustomerID], \n  [YearID]\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-9-sql-query-group-by-ssms.jpg\" alt=\"Requ\u00eate SQL GROUP BY \u00e9quivalente \u00e0 l'agr\u00e9gation avec SSIS\" class=\"wp-image-13725\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-9-sql-query-group-by-ssms.jpg 540w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-group-by-sum-9-sql-query-group-by-ssms-270x300.jpg 270w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><figcaption class=\"wp-element-caption\">Requ\u00eate SQL GROUP BY \u00e9quivalente \u00e0 l&rsquo;agr\u00e9gation avec SSIS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-conclusion-sur-la-transformation-ssis-aggregate\"><\/span>4. Conclusion sur la transformation SSIS Aggregate<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce tutoriel SSIS explique pas \u00e0 pas comment agr\u00e9ger des donn\u00e9es et calculer une somme avec un GROUP BY sur une table sans \u00e9crire de requ\u00eate SQL. Le composant est pratique pour des requ\u00eates simples, dans des cas plus complexes il est pr\u00e9f\u00e9rable d&rsquo;\u00e9crire une requ\u00eate SQL dans le composant OLE DB Source. Afin de conserver des packages simples et faciles \u00e0 maintenir.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Sur le th\u00e8me des regroupements et agr\u00e9gations de donn\u00e9es SSIS<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/ssis\/grouper-plusieurs-tables-avec-ssis-union-all\/\">Package pour grouper toutes les lignes de plusieurs tables<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/nombre-de-lignes-distinctes-avec-ssis\/\">Calculer le nombre de lignes distinctes d&rsquo;une table avec SSIS<\/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\">\nhttps:\/\/expert-only.com\/tutoriels-ssis\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Agr\u00e9ger et faire la somme de donn\u00e9es pour r\u00e9aliser l&rsquo;\u00e9quivalent du GROUP BY en SQL avec le composant SSIS Aggregate. Dans un projet ETL avec SSIS, il est courant de calculer des agr\u00e9gations de donn\u00e9es depuis une table SQL <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\" title=\"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10817,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-13644","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>Agr\u00e9ger des donn\u00e9es avec SSIS - Agr\u00e9gation - Integration Services<\/title>\n<meta name=\"description\" content=\"Agr\u00e9ger des donn\u00e9es avec SSIS depuis une table SQL Server, soit l&#039;\u00e9quivalent du GROUP BY SQL avec le composant transformation d&#039;agr\u00e9gation.\" \/>\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\/agreger-des-donnees-avec-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate\" \/>\n<meta property=\"og:description\" content=\"Agr\u00e9ger des donn\u00e9es avec SSIS depuis une table SQL Server, soit l&#039;\u00e9quivalent du GROUP BY SQL avec le composant transformation d&#039;agr\u00e9gation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-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-19T04:46:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-19T15:51:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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\/agreger-des-donnees-avec-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate\",\"datePublished\":\"2022-10-19T04:46:00+00:00\",\"dateModified\":\"2022-12-19T15:51:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\"},\"wordCount\":873,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\",\"name\":\"Agr\u00e9ger des donn\u00e9es avec SSIS - Agr\u00e9gation - Integration Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"datePublished\":\"2022-10-19T04:46:00+00:00\",\"dateModified\":\"2022-12-19T15:51:49+00:00\",\"description\":\"Agr\u00e9ger des donn\u00e9es avec SSIS depuis une table SQL Server, soit l'\u00e9quivalent du GROUP BY SQL avec le composant transformation d'agr\u00e9gation.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate\"}]},{\"@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":"Agr\u00e9ger des donn\u00e9es avec SSIS - Agr\u00e9gation - Integration Services","description":"Agr\u00e9ger des donn\u00e9es avec SSIS depuis une table SQL Server, soit l'\u00e9quivalent du GROUP BY SQL avec le composant transformation d'agr\u00e9gation.","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\/agreger-des-donnees-avec-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate","og_description":"Agr\u00e9ger des donn\u00e9es avec SSIS depuis une table SQL Server, soit l'\u00e9quivalent du GROUP BY SQL avec le composant transformation d'agr\u00e9gation.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-10-19T04:46:00+00:00","article_modified_time":"2022-12-19T15:51:49+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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\/agreger-des-donnees-avec-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate","datePublished":"2022-10-19T04:46:00+00:00","dateModified":"2022-12-19T15:51:49+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/"},"wordCount":873,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/","name":"Agr\u00e9ger des donn\u00e9es avec SSIS - Agr\u00e9gation - Integration Services","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","datePublished":"2022-10-19T04:46:00+00:00","dateModified":"2022-12-19T15:51:49+00:00","description":"Agr\u00e9ger des donn\u00e9es avec SSIS depuis une table SQL Server, soit l'\u00e9quivalent du GROUP BY SQL avec le composant transformation d'agr\u00e9gation.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/agreger-des-donnees-avec-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Agr\u00e9ger des donn\u00e9es avec SSIS et le composant Aggregate"}]},{"@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\/13644","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=13644"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/13644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10817"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=13644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=13644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=13644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}