{"id":1245,"date":"2023-05-11T07:21:00","date_gmt":"2023-05-11T05:21:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1245"},"modified":"2023-06-13T14:33:35","modified_gmt":"2023-06-13T12:33:35","slug":"synchroniser-colonnes-ssis-automatiquement","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/","title":{"rendered":"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Apprendre \u00e0 synchroniser les colonnes sources et cibles d&rsquo;un composant SSIS de mani\u00e8re automatique avec Visual Studio.<\/em><\/strong><\/h4>\n\n\n\n<p>C&rsquo;est \u00e0 dire comment synchroniser les colonnes SSIS sources et cibles automatiquement, en fonction de leur nom ? Cette astuce permet de d\u00e9velopper les packages SSIS de mani\u00e8re plus efficace. Pour relier les colonnes dans un composant SSIS il existe 2 options. Mapper \u00e0 la main constitue la premi\u00e8re option. La deuxi\u00e8me option est de les relier de mani\u00e8re automatique via l&rsquo;interface graphique de Visual Studio.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cr\u00e9er les tables avec les colonnes \u00e0 synchroniser<\/h2>\n\n\n\n<p>En effet, la gestion des colonnes n\u00e9cessite un pr\u00e9requis de taille. Pr\u00e9parer tous les noms de colonnes cibles avec les m\u00eames noms que les colonnes sources.&nbsp;En effet, pour relier un grand nombre de colonnes rapidement et \u00e9viter de perdre du temps avec des op\u00e9rations manuelles, suivre les \u00e9tapes ci-dessous.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Cr\u00e9er la table source depuis SSMS<\/h3>\n\n\n\n<p>Ex\u00e9cuter simplement le code SQL ci-dessous pour cr\u00e9er une table vide avec 20 colonnes.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE [dbo].[Source_Table]\n(\n    [Column_01] [nvarchar](20) NULL,\n    [Column_02] [nvarchar](20) NULL,\n    [Column_03] [nvarchar](20) NULL,\n    [Column_04] [nvarchar](20) NULL,\n    [Column_05] [nvarchar](20) NULL,\n    [Column_06] [nvarchar](20) NULL,\n    [Column_07] [nvarchar](20) NULL,\n    [Column_08] [nvarchar](20) NULL,\n    [Column_09] [nvarchar](20) NULL,\n    [Column_10] [nvarchar](20) NULL,\n    [Column_11] [nvarchar](20) NULL,\n    [Column_12] [nvarchar](20) NULL,\n    [Column_13] [nvarchar](20) NULL,\n    [Column_14] [nvarchar](20) NULL,\n    [Column_15] [nvarchar](20) NULL,\n    [Column_16] [nvarchar](20) NULL,\n    [Column_17] [nvarchar](20) NULL,\n    [Column_18] [nvarchar](20) NULL,\n    [Column_19] [nvarchar](20) NULL,\n    [Column_20] [nvarchar](20) NULL\n); \n\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Cr\u00e9er la table cible avec la m\u00eame structure<\/h3>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE [dbo].[Target_Table]\n(\n    [Column_01] [nvarchar](20) NULL,\n    [Column_02] [nvarchar](20) NULL,\n    [Column_03] [nvarchar](20) NULL,\n    [Column_04] [nvarchar](20) NULL,\n    [Column_05] [nvarchar](20) NULL,\n    [Column_06] [nvarchar](20) NULL,\n    [Column_07] [nvarchar](20) NULL,\n    [Column_08] [nvarchar](20) NULL,\n    [Column_09] [nvarchar](20) NULL,\n    [Column_10] [nvarchar](20) NULL,\n    [Column_11] [nvarchar](20) NULL,\n    [Column_12] [nvarchar](20) NULL,\n    [Column_13] [nvarchar](20) NULL,\n    [Column_14] [nvarchar](20) NULL,\n    [Column_15] [nvarchar](20) NULL,\n    [Column_16] [nvarchar](20) NULL,\n    [Column_17] [nvarchar](20) NULL,\n    [Column_18] [nvarchar](20) NULL,\n    [Column_19] [nvarchar](20) NULL,\n    [Column_20] [nvarchar](20) NULL\n); \n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-gerer-les-noms-de-colonnes-a-synchroniser-automatiquement-avec-ssis\">G\u00e9rer les noms de colonnes \u00e0 synchroniser automatiquement avec SSIS <\/h2>\n\n\n\n<p>Cette solution apporte un gain de temps important car elle permet aussi de&nbsp;limiter les erreurs manuelles et donc les r\u00e9gressions. Pour cela, cr\u00e9er simplement une connexion et un <a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\">flux de donn\u00e9es SSIS<\/a>. Soit une destination OLE DB sur une base de donn\u00e9es SQL Server par exemple. Les colonnes se synchronisent automatiquement \u00e0 la premi\u00e8re connexion.<\/p>\n\n\n\n<p>Cependant, apr\u00e8s une modification, les colonnes mises \u00e0 jour ne sont plus mapp\u00e9es avec celles de destination. L&rsquo;astuce est de nommer les colonnes cibles de la m\u00eame mani\u00e8re que les sources. En effet le lien entre les colonnes dans <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/integration-services\/sql-server-integration-services?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener noreferrer\">SSIS<\/a> est bas\u00e9 sur le nom des colonnes.<\/p>\n\n\n\n<p>Au pr\u00e9alable, r\u00e9aliser ces op\u00e9rations : <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>Nommer  les colonnes sources et destination<\/em><\/strong> de la m\u00eame mani\u00e8re, comme avec les 2 tables d&rsquo;exemple fournies<\/li>\n\n\n\n<li>Dans un flux de donn\u00e9es, <strong><em>Ouvrir le composant SSIS<\/em><\/strong> destination<\/li>\n<\/ul>\n\n\n\n<p>Note: les captures suivantes proviennent d&rsquo;une version Anglaise de Visual Studio<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"> 1. Ouvrir le composant OLE DB Destination depuis SSIS<\/h3>\n\n\n\n<p>Par d\u00e9faut, les colonnes avec les m\u00eames noms sont synchronis\u00e9s, mais en cas de changement de nom, il est possible de relier de mani\u00e8re automatique les colonnes sources et cibles.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"840\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-ole-db-destination-mapping-editor.jpg\" alt=\"Mapping des colonnes dans un flux de donn\u00e9es SSIS\" class=\"wp-image-25888\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-ole-db-destination-mapping-editor.jpg 780w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-ole-db-destination-mapping-editor-279x300.jpg 279w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-ole-db-destination-mapping-editor-768x827.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption class=\"wp-element-caption\"><em>Mapping des colonnes dans un flux de donn\u00e9es SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">2. Faire un clic-droit et s\u00e9lectionner l&rsquo;option de mappage par noms<\/h3>\n\n\n\n<p>Faire un <strong><em>clic droit dans la fen\u00eatre de mapping<\/em><\/strong> du composant \u00e0 synchroniser. Cliquer ensuite sur <strong><em>Map items by matching names<\/em><\/strong> pour les relier automatiquement, comme ci-dessous.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-automatic-data-flow-mapping-option.jpg\" alt=\"Option de mapping automatique des colonnes dans SSIS\" class=\"wp-image-25896\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-automatic-data-flow-mapping-option.jpg 780w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-automatic-data-flow-mapping-option-300x231.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-automatic-data-flow-mapping-option-768x591.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption class=\"wp-element-caption\"><em>Option de mapping automatique des colonnes dans SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Sur la version Fran\u00e7aise, l&rsquo;option est <strong><em>Mapper les \u00e9l\u00e9ments par noms correspondants<\/em><\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Les colonnes SSIS sources et cibles ayant le m\u00eame nom sont mapp\u00e9es<\/h3>\n\n\n\n<p>Toutes les colonnes sont maintenant reli\u00e9es.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"780\" height=\"840\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-data-flow-all-columns-mapped.jpg\" alt=\"Synchroniser les colonnes SSIS automatiquement depuis un flux de donn\u00e9es\" class=\"wp-image-25900\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-data-flow-all-columns-mapped.jpg 780w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-data-flow-all-columns-mapped-279x300.jpg 279w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-data-flow-all-columns-mapped-768x827.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption class=\"wp-element-caption\"><em>Synchroniser les colonnes SSIS automatiquement depuis un flux de donn\u00e9es<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Nommer les colonnes sources et cibles de mani\u00e8re uniforme<\/h2>\n\n\n\n<p>Cette option connecte les colonnes sources et destination en une seconde. M\u00eame apr\u00e8s une \u00e9ventuelle modification des caract\u00e9ristiques des champs sources qui alimentent le composant. En effet, nommer les colonnes sources et cibles exactement de la m\u00eame fa\u00e7on permet de faire le mapping automatiquement. Le mapping par d\u00e9faut des colonnes dans SSIS est bas\u00e9 sur leur nom.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion<\/h3>\n\n\n\n<p>Le mappage automatique avec SSIS offre une fonctionnalit\u00e9 tr\u00e8s utile pour la gestion des donn\u00e9es. Lorsque vous utilisez cette fonction, toutes les colonnes source qui portent le m\u00eame nom que la cible sont automatiquement mapp\u00e9es. Cela signifie que SSIS identifie et connecte ces colonnes en correspondance avec leur nom.<\/p>\n\n\n\n<p>Cette caract\u00e9ristique r\u00e9duit consid\u00e9rablement le temps n\u00e9cessaire pour configurer manuellement chaque mappage, surtout dans le cas o\u00f9 vous travaillez avec de grands ensembles de donn\u00e9es avec un grand nombre de colonnes. Par cons\u00e9quent, le mappage automatique est une fonction cl\u00e9 pour am\u00e9liorer l&rsquo;efficacit\u00e9 et l&rsquo;exactitude lors de la manipulation de donn\u00e9es avec SSIS.<\/p>\n\n\n\n<p>Enfin, pour continuer \u00e0 apprendre la gestion des donn\u00e9es avec SSIS, voici comment <a href=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\">exporter une table vers un fichier Excel<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"GNRPrngExY\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/\">Exporter une table SQL Server vers un fichier Excel avec SSIS<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Exporter une table SQL Server vers un fichier Excel avec SSIS\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/exporter-table-sql-server-vers-excel-ssis\/embed\/#?secret=PREbELto15#?secret=GNRPrngExY\" data-secret=\"GNRPrngExY\" 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>Apprendre \u00e0 synchroniser les colonnes sources et cibles d&rsquo;un composant SSIS de mani\u00e8re automatique avec Visual Studio. C&rsquo;est \u00e0 dire comment synchroniser les colonnes SSIS sources et cibles automatiquement, en fonction de leur nom ? Cette astuce permet de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\" title=\"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10872,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-1245","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>Comment synchroniser les colonnes SSIS automatiquement ?<\/title>\n<meta name=\"description\" content=\"Comment synchroniser les colonnes SSIS automatiquement avec Visual Studio ? M\u00e9thode pour gagner du temps lors des d\u00e9veloppements ETL.\" \/>\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\/synchroniser-colonnes-ssis-automatiquement\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?\" \/>\n<meta property=\"og:description\" content=\"Comment synchroniser les colonnes SSIS automatiquement avec Visual Studio ? M\u00e9thode pour gagner du temps lors des d\u00e9veloppements ETL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\" \/>\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-05-11T05:21:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-13T12:33:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_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=\"4 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\/synchroniser-colonnes-ssis-automatiquement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?\",\"datePublished\":\"2023-05-11T05:21:00+00:00\",\"dateModified\":\"2023-06-13T12:33:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\"},\"wordCount\":729,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\",\"name\":\"Comment synchroniser les colonnes SSIS automatiquement ?\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"datePublished\":\"2023-05-11T05:21:00+00:00\",\"dateModified\":\"2023-06-13T12:33:35+00:00\",\"description\":\"Comment synchroniser les colonnes SSIS automatiquement avec Visual Studio ? M\u00e9thode pour gagner du temps lors des d\u00e9veloppements ETL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?\"}]},{\"@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":"Comment synchroniser les colonnes SSIS automatiquement ?","description":"Comment synchroniser les colonnes SSIS automatiquement avec Visual Studio ? M\u00e9thode pour gagner du temps lors des d\u00e9veloppements ETL.","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\/synchroniser-colonnes-ssis-automatiquement\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?","og_description":"Comment synchroniser les colonnes SSIS automatiquement avec Visual Studio ? M\u00e9thode pour gagner du temps lors des d\u00e9veloppements ETL.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-11T05:21:00+00:00","article_modified_time":"2023-06-13T12:33:35+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?","datePublished":"2023-05-11T05:21:00+00:00","dateModified":"2023-06-13T12:33:35+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/"},"wordCount":729,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/","url":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/","name":"Comment synchroniser les colonnes SSIS automatiquement ?","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","datePublished":"2023-05-11T05:21:00+00:00","dateModified":"2023-06-13T12:33:35+00:00","description":"Comment synchroniser les colonnes SSIS automatiquement avec Visual Studio ? M\u00e9thode pour gagner du temps lors des d\u00e9veloppements ETL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-273B124DF7D_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/synchroniser-colonnes-ssis-automatiquement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment synchroniser les colonnes SSIS automatiquement dans un flux de donn\u00e9es ?"}]},{"@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\/1245","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=1245"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1245\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10872"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}