{"id":1342,"date":"2022-08-30T06:57:00","date_gmt":"2022-08-30T04:57:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1342"},"modified":"2022-10-05T17:22:30","modified_gmt":"2022-10-05T15:22:30","slug":"creer-un-data-flow-ssis-simple","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/","title":{"rendered":"Cr\u00e9er un data flow SSIS simple"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment cr\u00e9er un data flow simple avec SSIS et Visual Studio 2019?<\/em><\/strong><\/h4>\n\n\n\n<p>Ce tutoriel explique comment cr\u00e9er un flux de donn\u00e9es SSIS, aussi appel\u00e9 data flow SSIS en Anglais. Soit configurer un package pour extraire, transformer si besoin et enfin charger les donn\u00e9es dans une autre <a href=\"https:\/\/expert-only.com\/base-sql-server\/creer-une-base-de-donnees-sql-server-avec-un-script\/\">base de donn\u00e9es<\/a> ou une autre <a href=\"https:\/\/expert-only.com\/t-sql\/table-sql-server-avec-partitions\/\">table SQL<\/a>. Un flux de donn\u00e9es permet par exemple de copier des donn\u00e9es d&rsquo;une base de donn\u00e9es MS SQL locale vers fichier plat ou inversement. Ou plus g\u00e9n\u00e9ralement d&rsquo;une source de donn\u00e9es vers une cible. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-creer-un-data-flow-ssis-basique-pour-transferer-des-donnees-entre-deux-tables\">Cr\u00e9er un data flow SSIS basique pour transf\u00e9rer des donn\u00e9es entre deux tables<\/h2>\n\n\n\n<p>SSIS est <a href=\"https:\/\/expert-only.com\/concepts\/etl-extract-transform-load\/\">la brique ETL<\/a> de la suite d\u00e9cisionnelle SQL Server BI, c&rsquo;est \u00e0 dire que les packages SSIS Microsoft servent \u00e0 int\u00e9grer et traiter des donn\u00e9es. Dans un package <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/integration-services\/expressions\/syntax-ssis?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS<\/a>, les \u00e9l\u00e9ments de base sont les flux de contr\u00f4le et les flux de donn\u00e9es. De plus, les suite logicielles d&rsquo;int\u00e9gration de donn\u00e9es sont au c\u0153ur des projets de <a href=\"https:\/\/expert-only.com\/concepts\/entrepot-de-donnees-ou-data-warehouse\/\">d\u00e9veloppement des entrep\u00f4ts de donn\u00e9es<\/a>.<\/p>\n\n\n\n<p>Un package SSIS est structur\u00e9 comme suit:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Package SSIS<\/strong> (Package.dtsx par exemple)<ul><li><strong>Flux de contr\u00f4le<\/strong> (Control Flow)<ul><li><strong>Flux de donn\u00e9es<\/strong> (Data Flow)<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<p>C&rsquo;est \u00e0 dire qu&rsquo;un package SSIS contient un ou plusieurs flux de contr\u00f4le, et les flux de contr\u00f4le contiennent eux-m\u00eames un ou plusieurs flux de donn\u00e9es.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Pr\u00e9requis pour le tutoriel est d&rsquo;installer Visual Studio 2019 et les projets SSIS<\/h4>\n\n\n\n<p>Avant de d\u00e9marrer ce tutoriel: <\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Commencer par <a href=\"https:\/\/expert-only.com\/ssis\/installer-ssis-visual-studio-2019\/\">installer Visual Studio 2019 et l&rsquo;extension des projets SSIS<\/a>.<\/li><li>Ensuite, <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">cr\u00e9er un projet SSIS<\/a>.<\/li><li><a href=\"https:\/\/expert-only.com\/ssis\/creer-connexion-base-sql-server-ssis\/\">Cr\u00e9er une connexion \u00e0 la base SQL Server<\/a> depuis le gestionnaire de connexions SSIS.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">1. Ajouter le flux de donn\u00e9es au flux de contr\u00f4le et cr\u00e9er la table source<\/h3>\n\n\n\n<p>Pour commencer, depuis la fen\u00eatre Visual Studio 2019, faire glisser sur le composant <em>Data Flow Task<\/em> sur l&rsquo;espace de travail dans l&rsquo;onglet Control Flow. Ou double-cliquer sur le composant depuis la bo\u00eete \u00e0 outils SSIS. Puis double cliquer dessus pour l&rsquo;\u00e9diter.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"685\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow.jpg\" alt=\"Faire glisser le flux de donn\u00e9es dans le flux de contr\u00f4le SSIS\" class=\"wp-image-11379\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow.jpg 729w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-ssis-data-flow-to-control-flow-300x282.jpg 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><figcaption><strong>Faire glisser le flux de donn\u00e9es dans le flux de contr\u00f4le SSIS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Ce tutoriel utilise cette table, cr\u00e9\u00e9e dans ce <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-primary-key\/\">tutoriel sur la cr\u00e9ation des tables MS SQL avec une clef primaire<\/a>. Le code de cr\u00e9ation de la table source est disponible ci-dessous. Pour cr\u00e9er la table et ins\u00e9rer les donn\u00e9es, se connecter \u00e0 la base de donn\u00e9es avec <a href=\"https:\/\/expert-only.com\/ssms\/telecharger-sql-server-management-studio-18-ssms\/\">SSMS<\/a>.<\/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\n\n-- Ins\u00e9rer 4 lignes diff\u00e9rentes\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 1, 'Ali','Ahmed','Cairo','Egypt');\n\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 2, 'Johnny','John','Toronto','Canada');\n\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 3, 'John','Doe','Mexico City','Mexico');\n\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 4, 'Shu','Abbas','Paris','France');\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. Configurer la source de donn\u00e9es OLE DB<\/h3>\n\n\n\n<p>Le curseur se trouve maintenant dans l&rsquo;onglet <em>Data Flow<\/em>. Depuis cet onglet, s\u00e9lectionner l\u2019outil <em>OLE DB Source<\/em> et le faire glisser sur l\u2019espace de travail. <\/p>\n\n\n\n<p>Double cliquer sur le composant. Depuis le menu OLE DB Source editor, sur l&rsquo;onglet <em>Connection Manager<\/em>. Puis s\u00e9lectionner la base de donn\u00e9es et la table source pour notre flux de donn\u00e9es.<\/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-ole-db-source-editor-config-and-preview.jpg\" alt=\"Configurer la table source des clients avec l'\u00e9diteur OLE DB et pr\u00e9visualiser les donn\u00e9es avec SSIS\" class=\"wp-image-11387\" width=\"805\" height=\"693\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview.jpg 805w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview-300x258.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-config-and-preview-768x661.jpg 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><figcaption>Configurer la table source des clients avec l&rsquo;\u00e9diteur OLE DB et pr\u00e9visualiser les donn\u00e9es <\/figcaption><\/figure><\/div>\n\n\n<p>Puis aller dans l&rsquo;onglet <em>Columns<\/em> et v\u00e9rifier que les colonnes de la table sont pr\u00e9sentes. Enfin s\u00e9lectionner celles dont le contenu est \u00e0 exporter. Effectuer le mapping en fonction des noms de colonnes. Par d\u00e9faut les colonnes en sortie ont le m\u00eame nom que les colonnes de la table source.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"622\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-column-mappings.jpg\" alt=\"V\u00e9rifier le mappage des colonnes depuis l'onglet Columns\" class=\"wp-image-11394\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-column-mappings.jpg 742w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-source-editor-column-mappings-300x251.jpg 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><figcaption>V\u00e9rifier le mappage des colonnes depuis l&rsquo;onglet Columns<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">3. Cr\u00e9er une colonne d\u00e9riv\u00e9e SSIS<\/h3>\n\n\n\n<p>Cr\u00e9er une transformation avec le composant SSIS <em>Derived Column<\/em>, c&rsquo;est \u00e0 dire colonne d\u00e9riv\u00e9e. L&rsquo;ajouter au flux de donn\u00e9es, le relier \u00e0 l&rsquo;outil OLE DB Source puis double cliquer pour ouvrir le composant.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"537\" height=\"589\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-add-and-link-derived-column-to-data-flow.jpg\" alt=\"Ajouter puis relier et ouvrir le composant colonne d\u00e9riv\u00e9e SSIS\" class=\"wp-image-11403\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-add-and-link-derived-column-to-data-flow.jpg 537w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-add-and-link-derived-column-to-data-flow-274x300.jpg 274w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/><figcaption>Ajouter puis relier et ouvrir le composant colonne d\u00e9riv\u00e9e SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>La modification des donn\u00e9es se fait dans le menu <em>Derived Column Transformation Editor<\/em>. Ins\u00e9rer une colonne ou effectuer des modifications gr\u00e2ce aux diff\u00e9rentes fonctions SSIS depuis la fen\u00eatre de droite.<\/p>\n\n\n\n<p>Ici le but est de transformer le nom de famille et le pr\u00e9nom dans une colonne cible avec les initiales de chaque client. Suivre les \u00e9tapes suivantes: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Cr\u00e9er donc une nouvelle colonne appel\u00e9e <em>Initials<\/em>.<\/li><li>Choisir ajouter comme une nouvelle colonne pour ne pas remplacer une colonne existante.<\/li><li>Remplir ensuite la formule<\/li><li>Ici le choix est d&rsquo;ajouter une nouvelle colonne, avec une longueur de 8 caract\u00e8res.<\/li><\/ul>\n\n\n\n<p>Formule utilis\u00e9e dans le package r\u00e9cup\u00e8re la premi\u00e8re lettre du pr\u00e9nom, puis concat\u00e8ne le r\u00e9sultat avec la premi\u00e8re lettre du nom de famille et enfin force le type avec une longueur de 8 caract\u00e8res.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">(DT_WSTR,8)(LEFT(FirstName,1) + LEFT(LastName,1))<\/pre>\n\n\n\n<p><strong>L&rsquo;\u00e9quivalent du type de donn\u00e9es NVARCHAR de SQL Server est le type DT_WSTR de SSIS.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"632\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials.jpg\" alt=\"\" class=\"wp-image-11412\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials.jpg 831w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials-300x228.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials-768x584.jpg 768w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-derived-column-to-create-initials-80x60.jpg 80w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">4. Ajouter la destination OLE DB dans le data flow et cr\u00e9er la table cible <\/h3>\n\n\n\n<p>Pour stocker les donn\u00e9es modifi\u00e9es, commencer par <a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\">cr\u00e9er la table<\/a> cible avec le code SQL suivant. C&rsquo;est donc la m\u00eame structure de <a href=\"https:\/\/expert-only.com\/t-sql\/modifier-une-table-sql-server\/\">table avec une colonne suppl\u00e9mentaire<\/a> pour contenir les initiales. <\/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].[Customers_with_initials](\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   [Initials] [nvarchar](8) NULL,\n   CONSTRAINT [CustomersInitialsPKCustomerID] PRIMARY KEY CLUSTERED ([CustomerID] ASC)\n);\nGO<\/pre>\n\n\n\n<p>S\u00e9lectionner ensuite le composant <em>OLE DB Destination<\/em> et le glisser sur l&rsquo;espace de travail, dans le flux de donn\u00e9es. Puis relier l&rsquo;outil <em>Derived Column<\/em> \u00e0 ce dernier. Enfin, double cliquer dessus pour l&rsquo;\u00e9diter.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"578\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-and-link-ssis-ole-db-destination-to-derived-column.jpg\" alt=\"Ajouter la destination OLE DB au package SSIS\" class=\"wp-image-11427\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-and-link-ssis-ole-db-destination-to-derived-column.jpg 540w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/add-and-link-ssis-ole-db-destination-to-derived-column-280x300.jpg 280w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><figcaption>Ajouter la destination OLE DB au package SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>Ouvrir le menu OLE DB Destination Editor. Dans l&rsquo;onglet connexion manager, choisir la table destinataire du chargement.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"635\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-destination-editor-condigure-table.jpg\" alt=\"Configurer la table de destination pour contenir les donn\u00e9es dans le data flow SSIS\" class=\"wp-image-11421\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-destination-editor-condigure-table.jpg 751w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-ole-db-destination-editor-condigure-table-300x254.jpg 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><figcaption>Configurer la table de destination pour contenir les donn\u00e9es dans le data flow SSIS<\/figcaption><\/figure><\/div>\n\n\n<p>Puis dans l\u2019onglet <em>Mappings<\/em>, v\u00e9rifier que les colonnes sont reli\u00e9es correctement. Par d\u00e9faut, l&rsquo;\u00e9diteur de packages Integration Services permet par d\u00e9faut de <a href=\"https:\/\/expert-only.com\/ssis\/synchroniser-les-colonnes-automatiquement-avec-ssis\/\">relier automatiquement les colonnes avec le m\u00eame nom<\/a>.<\/p>\n\n\n\n<p><strong>C&rsquo;est une <a href=\"https:\/\/expert-only.com\/ssis\/bonnes-pratiques-microsoft-ssis\/\">bonne pratique SSIS<\/a> de renommer les colonnes en amont pour faciliter le mappage des donn\u00e9es.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"635\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ole-db-destination-editor-edit-mapping-manually.jpg\" alt=\"Mapper les colonnes \u00e0 la main si n\u00e9cessaire avec SSIS\" class=\"wp-image-11432\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ole-db-destination-editor-edit-mapping-manually.jpg 751w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ole-db-destination-editor-edit-mapping-manually-300x254.jpg 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><figcaption>Mapper les colonnes \u00e0 la main si n\u00e9cessaire avec SSIS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">5. Ex\u00e9cuter le package SSIS et v\u00e9rifier les r\u00e9sultats avec SSMS<\/h2>\n\n\n\n<p>Maintenant, pour lancer le chargement, il faut ex\u00e9cuter le package depuis Visual Studio. Pour cela, cliquer sur le bouton <em>Start<\/em> ou directement avec le raccourci <em>F5<\/em>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/execute-ssis-package-with-visual-studio-2019.jpg\" alt=\"Ex\u00e9cuter le package SSIS avec un data flow basique\" class=\"wp-image-11441\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/execute-ssis-package-with-visual-studio-2019.jpg 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/execute-ssis-package-with-visual-studio-2019-300x257.jpg 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption>Ex\u00e9cuter le package SSIS avec un data flow basique<\/figcaption><\/figure><\/div>\n\n\n<p>Pour v\u00e9rifier les donn\u00e9es dans les deux tables, il suffit d&rsquo;ex\u00e9cuter ces <a href=\"https:\/\/expert-only.com\/t-sql\/requetes-select-sql-server\/\">requ\u00eates de s\u00e9lection depuis SSMS<\/a>:<\/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];\nselect * from [dbo].[Customers_with_initials];\n<\/pre>\n\n\n\n<p> <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"400\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/check-package-execution-result-ssms-query.jpg\" alt=\"\" class=\"wp-image-11482\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/check-package-execution-result-ssms-query.jpg 730w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/check-package-execution-result-ssms-query-300x164.jpg 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><figcaption>Requ\u00eate SSMS avec les deux tables et les initiales cr\u00e9ent par le package SSIS<\/figcaption><\/figure><\/div>\n\n\n<p><\/p>\n\n\n\n<p>Voici donc comment cr\u00e9er un data flow SSIS basique pour copier des donn\u00e9es d&rsquo;une table \u00e0 une autre et ajouter une colonne d\u00e9riv\u00e9e de deux colonnes existantes. Pour aller encore plus loin dans la manipulation de donn\u00e9es avec SSIS, voici <a href=\"https:\/\/expert-only.com\/ssis\/charger-des-cellules-excel-avec-ssis\/\">comment charger uniquement une plage de cellules depuis un fichier Excel<\/a> vers une base de donn\u00e9es SQL.<\/p>\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\/ssis\/charger-un-fichier-texte-dans-une-base-sql-server-avec-ssis\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment cr\u00e9er un data flow simple avec SSIS et Visual Studio 2019? Ce tutoriel explique comment cr\u00e9er un flux de donn\u00e9es SSIS, aussi appel\u00e9 data flow SSIS en Anglais. Soit configurer un package pour extraire, transformer si besoin et <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\" title=\"Cr\u00e9er un data flow SSIS simple\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10617,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-1342","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>Cr\u00e9er un data flow SSIS simple - Integration Services<\/title>\n<meta name=\"description\" content=\"Tutoriel pour cr\u00e9er un Data Flow SSIS dans un package et transf\u00e9rer des donn\u00e9es entre deux tables SQL Server avec un flux de donn\u00e9es basique.\" \/>\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\/creer-un-data-flow-ssis-simple\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er un data flow SSIS simple\" \/>\n<meta property=\"og:description\" content=\"Tutoriel pour cr\u00e9er un Data Flow SSIS dans un package et transf\u00e9rer des donn\u00e9es entre deux tables SQL Server avec un flux de donn\u00e9es basique.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\" \/>\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-08-30T04:57:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-05T15:22:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_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=\"8 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\/creer-un-data-flow-ssis-simple\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er un data flow SSIS simple\",\"datePublished\":\"2022-08-30T04:57:00+00:00\",\"dateModified\":\"2022-10-05T15:22:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\"},\"wordCount\":1163,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\",\"name\":\"Cr\u00e9er un data flow SSIS simple - Integration Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"datePublished\":\"2022-08-30T04:57:00+00:00\",\"dateModified\":\"2022-10-05T15:22:30+00:00\",\"description\":\"Tutoriel pour cr\u00e9er un Data Flow SSIS dans un package et transf\u00e9rer des donn\u00e9es entre deux tables SQL Server avec un flux de donn\u00e9es basique.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er un data flow SSIS simple\"}]},{\"@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":"Cr\u00e9er un data flow SSIS simple - Integration Services","description":"Tutoriel pour cr\u00e9er un Data Flow SSIS dans un package et transf\u00e9rer des donn\u00e9es entre deux tables SQL Server avec un flux de donn\u00e9es basique.","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\/creer-un-data-flow-ssis-simple\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er un data flow SSIS simple","og_description":"Tutoriel pour cr\u00e9er un Data Flow SSIS dans un package et transf\u00e9rer des donn\u00e9es entre deux tables SQL Server avec un flux de donn\u00e9es basique.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-08-30T04:57:00+00:00","article_modified_time":"2022-10-05T15:22:30+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_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":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er un data flow SSIS simple","datePublished":"2022-08-30T04:57:00+00:00","dateModified":"2022-10-05T15:22:30+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/"},"wordCount":1163,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/","url":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/","name":"Cr\u00e9er un data flow SSIS simple - Integration Services","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","datePublished":"2022-08-30T04:57:00+00:00","dateModified":"2022-10-05T15:22:30+00:00","description":"Tutoriel pour cr\u00e9er un Data Flow SSIS dans un package et transf\u00e9rer des donn\u00e9es entre deux tables SQL Server avec un flux de donn\u00e9es basique.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/digitization-FD44BBF7CF9_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er un data flow SSIS simple"}]},{"@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\/1342","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=1342"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1342\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10617"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}