{"id":1176,"date":"2024-03-18T06:51:39","date_gmt":"2024-03-18T05:51:39","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1176"},"modified":"2024-03-18T12:54:22","modified_gmt":"2024-03-18T11:54:22","slug":"configurer-la-log-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/","title":{"rendered":"Configurer la Log dans un Package SSIS"},"content":{"rendered":"\n<p class=\"has-text-align-left\"><em><strong>Configurer la gestion de la log et enregistrer les \u00e9v\u00e8nements g\u00e9n\u00e9r\u00e9s dans un package SSIS en 3 \u00e9tapes pour mieux stocker les diff\u00e9rentes erreurs et avertissements.<\/strong><\/em><\/p>\n\n\n\n<p>Il existe diff\u00e9rentes solutions pour configurer la log des packages SSIS, comme le stockage dans la table sysssislog. Configurer les fichiers de logs permet de surveiller l&rsquo;ex\u00e9cution des packages SSIS pendant les batchs. Voici plusieurs solutions pour g\u00e9rer et consulter les logs SSIS:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La premi\u00e8re consiste \u00e0 le faire manuellement dans Microsoft SQL Server Management Studio, depuis l&rsquo;historique des jobs.<\/li>\n\n\n\n<li>La deuxi\u00e8me solution est d&rsquo;utiliser les t\u00e2ches SQL personnalis\u00e9es permettant de remplir une table de log ou des m\u00e9tadonn\u00e9es.<\/li>\n\n\n\n<li>Enfin, la troisi\u00e8me solution utilise les fichiers de logs SSIS. Un syst\u00e8me de fichiers de log ou de journal d&rsquo;<a href=\"https:\/\/fr.wikipedia.org\/wiki\/Historique_(informatique)\" target=\"_blank\" rel=\"noreferrer noopener\">historique<\/a> permet de tracer tous les \u00e9v\u00e8nements importants.<\/li>\n<\/ul>\n\n\n\n<p>Voici donc comment configurer et activer pas \u00e0 pas la journalisation depuis Integration Service. Par ailleurs, la solution utilisant la table de log SQL Server (sysssislog) est la plus populaire. Elle permet de rechercher les \u00e9v\u00e8nements directement dans une base SQL Server.<\/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\/configurer-la-log-ssis\/#1-activer-la-log-ssis-dans-un-package-ssis-depuis-un-clic-droit\" >1. Activer la log SSIS dans un Package SSIS depuis un clic droit<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#2-configurer-la-journalisation-du-package-ssis\" >2. Configurer la journalisation du package SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#3-choisir-les-evenements-pour-la-log-du-package-ssis\" >3.&nbsp;Choisir les \u00e9v\u00e8nements pour la log du package SSIS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-activer-la-log-ssis-dans-un-package-ssis-depuis-un-clic-droit\"><span class=\"ez-toc-section\" id=\"1-activer-la-log-ssis-dans-un-package-ssis-depuis-un-clic-droit\"><\/span>1. Activer la log SSIS dans un Package SSIS depuis un clic droit<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8rement, faire un clic-droit dans l&rsquo;espace de travail du <strong>Control Flow<\/strong>, appel\u00e9 Flux de contr\u00f4le en Fran\u00e7ais. Puis cliquer sur&nbsp;<strong>Logging<\/strong>&nbsp;afin d&rsquo;activer la table des&nbsp;logs.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"406\" height=\"406\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs.jpg\" alt=\"Configurer la Log dans un Package SSIS depuis un clic droit sur flux de contr\u00f4le\" class=\"wp-image-1180\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs.jpg 406w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-300x300.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-150x150.jpg 150w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><figcaption class=\"wp-element-caption\"><em>Configurer la Log dans un Package SSIS depuis un clic droit sur flux de contr\u00f4le<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-configurer-la-journalisation-du-package-ssis\"><span class=\"ez-toc-section\" id=\"2-configurer-la-journalisation-du-package-ssis\"><\/span>2. Configurer la journalisation du package SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une fois dans la fen\u00eatre&nbsp;<strong>Configure SSIS Logs&nbsp;<\/strong>dans l&rsquo;onglet&nbsp;<strong>Providers and Logs<\/strong>&nbsp;configurer la fen\u00eatre comme ci-dessous. Pour le type de stockage des logs, plusieurs choix sont propos\u00e9s, dans cet exemple, choisir le type SQL Server. C&rsquo;est \u00e0 dire <strong>SSIS Log provider for SQL Server<\/strong> pour stocker les logs dans une table. Choisir ensuite la configuration.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"696\" height=\"586\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-2.jpg\" alt=\"S\u00e9lectionner le type de fournisseur de log SQL Server pour SSIS\" class=\"wp-image-1181\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-2.jpg 696w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-2-300x253.jpg 300w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><figcaption class=\"wp-element-caption\"><em>S\u00e9lectionner le type de fournisseur de log SQL Server pour SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Noter&nbsp;qu&rsquo;il est impossible de choisir le nom de la table pour stocker les logs. La table de log SSIS s&rsquo;appelle <strong>dbo.sysssislog<\/strong>. Concernant la manipulation de donn\u00e9es avec SQL Server, voici comment <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/pivot-sql-server\/\">utiliser le PIVOT SQL Server.<\/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=\"j6GVmIvPkg\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/pivot-sql-server\/\">Exemple de Requ\u00eate PIVOT SQL Server<\/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\u00a0Exemple de Requ\u00eate PIVOT SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/pivot-sql-server\/embed\/#?secret=gkIrNe6I9l#?secret=j6GVmIvPkg\" data-secret=\"j6GVmIvPkg\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-nbsp-choisir-les-evenements-pour-la-log-du-package-ssis\"><span class=\"ez-toc-section\" id=\"3-choisir-les-evenements-pour-la-log-du-package-ssis\"><\/span>3.&nbsp;Choisir les \u00e9v\u00e8nements pour la log du package SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, il est possible de personnaliser le suivi des traitements dans l&rsquo;onglet <strong>Details<\/strong>. Voici une configuration pour \u00e9viter de g\u00e9n\u00e9rer des volumes trop importants de&nbsp;logs. Avec uniquement les options OnError, OnPostExecute et OnPreExecute.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>OnError&nbsp;<\/strong>: Retranscrit les erreurs survenues au niveau&nbsp;Control Flow&nbsp;et&nbsp;Data Flow.<\/li>\n\n\n\n<li><strong>OnPostExecute&nbsp;<\/strong>: Retranscrit la fin des t\u00e2ches du&nbsp;Control Flow.<\/li>\n\n\n\n<li><strong>OnPreExecute&nbsp;<\/strong>: Retranscrit le d\u00e9but des t\u00e2ches dans le Control Flow.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"587\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-3.jpg\" alt=\"Choisir les trois \u00e9v\u00e8nements SSIS OnError, OnPreExecute et OnPostExecute\" class=\"wp-image-1182\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-3.jpg 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/ssis-2008-gestion-options-logs-3-300x252.jpg 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><em>Choisir les trois \u00e9v\u00e8nements SSIS OnError, OnPreExecute et OnPostExecute<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conclusion-sur-la-journalisation-ssis\">Conclusion sur la journalisation SSIS<\/h3>\n\n\n\n<p>Il est donc assez facile de configurer la log dans un package SSIS pour l&rsquo;enrichir selon les besoins du projet en cochant des \u00e9v\u00e9nements sp\u00e9cifiques \u00e0 surveiller. Depuis la fen\u00eatre&nbsp;Configure SSIS Logs, s\u00e9lectionner simplement les \u00e9v\u00e8nements clefs. Il est recommand\u00e9 de configurer la log SSIS avec les informations n\u00e9cessaires uniquement pour ne pas avoir de r\u00e9sultat trop verbeux.<\/p>\n\n\n\n<p>Pour rappel, s\u00e9lectionner tous les \u00e9v\u00e8nements rend la log longue et difficile \u00e0 analyser. Voici enfin un article avec la liste de toutes les erreurs SSIS rencontr\u00e9es dans les logs.<\/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=\"0Uja5AmWD2\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\">Liste de toutes les erreurs 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\u00a0Liste de toutes les erreurs SSIS\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/embed\/#?secret=gNPkKWupcb#?secret=0Uja5AmWD2\" data-secret=\"0Uja5AmWD2\" 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>Configurer la gestion de la log et enregistrer les \u00e9v\u00e8nements g\u00e9n\u00e9r\u00e9s dans un package SSIS en 3 \u00e9tapes pour mieux stocker les diff\u00e9rentes erreurs et avertissements. Il existe diff\u00e9rentes solutions pour configurer la log des packages SSIS, comme le <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/\" title=\"Configurer la Log dans un Package SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-1176","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>Configurer la Log dans un Package SSIS - Expert-Only<\/title>\n<meta name=\"description\" content=\"Configurer la log dans un package SSIS pour enregistrer les \u00e9v\u00e8nements comme les erreurs et les avertissements dans une table SQL Server.\" \/>\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\/configurer-la-log-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configurer la Log dans un Package SSIS\" \/>\n<meta property=\"og:description\" content=\"Configurer la log dans un package SSIS pour enregistrer les \u00e9v\u00e8nements comme les erreurs et les avertissements dans une table SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-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=\"2024-03-18T05:51:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-18T11:54:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_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\/configurer-la-log-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Configurer la Log dans un Package SSIS\",\"datePublished\":\"2024-03-18T05:51:39+00:00\",\"dateModified\":\"2024-03-18T11:54:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/\"},\"wordCount\":603,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/\",\"name\":\"Configurer la Log dans un Package SSIS - Expert-Only\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"datePublished\":\"2024-03-18T05:51:39+00:00\",\"dateModified\":\"2024-03-18T11:54:22+00:00\",\"description\":\"Configurer la log dans un package SSIS pour enregistrer les \u00e9v\u00e8nements comme les erreurs et les avertissements dans une table SQL Server.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configurer la Log dans un Package SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Configurer la Log dans un Package SSIS - Expert-Only","description":"Configurer la log dans un package SSIS pour enregistrer les \u00e9v\u00e8nements comme les erreurs et les avertissements dans une table SQL Server.","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\/configurer-la-log-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Configurer la Log dans un Package SSIS","og_description":"Configurer la log dans un package SSIS pour enregistrer les \u00e9v\u00e8nements comme les erreurs et les avertissements dans une table SQL Server.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-18T05:51:39+00:00","article_modified_time":"2024-03-18T11:54:22+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_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\/configurer-la-log-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Configurer la Log dans un Package SSIS","datePublished":"2024-03-18T05:51:39+00:00","dateModified":"2024-03-18T11:54:22+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/"},"wordCount":603,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/","name":"Configurer la Log dans un Package SSIS - Expert-Only","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","datePublished":"2024-03-18T05:51:39+00:00","dateModified":"2024-03-18T11:54:22+00:00","description":"Configurer la log dans un package SSIS pour enregistrer les \u00e9v\u00e8nements comme les erreurs et les avertissements dans une table SQL Server.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/configurer-la-log-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Configurer la Log dans un Package SSIS"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1176","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=1176"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1176\/revisions"}],"predecessor-version":[{"id":30762,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1176\/revisions\/30762"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10867"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}