{"id":1291,"date":"2023-05-08T06:25:00","date_gmt":"2023-05-08T04:25:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1291"},"modified":"2023-05-16T13:25:13","modified_gmt":"2023-05-16T11:25:13","slug":"creer-une-pause-dans-un-package-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/","title":{"rendered":"Cr\u00e9er une pause dans un package SSIS"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Cr\u00e9er une pause dans un package SSIS avec une requ\u00eate T-SQL et la fonction WAIT FOR DELAY.<\/em><\/strong><\/h4>\n\n\n\n<p>L\u2019ETL SSIS de Microsoft ne propose pas de composant natif d\u00e9di\u00e9 pour cr\u00e9er une pause dans un package SSIS. Qu&rsquo;elle soit de quelques secondes ou quelques minutes dans un flux de contr\u00f4le entre 2 s\u00e9quences par exemple. Pour marquer un temps d&rsquo;arr\u00eat entre l&rsquo;ex\u00e9cution de plusieurs t\u00e2ches SSIS, de requ\u00eates SQL, ou de conteneurs, une bonne alternative est de <a href=\"https:\/\/csharp.net-tutorials.com\/fr\/112\/control-structures\/les-boucles\/\" target=\"_blank\" rel=\"noreferrer noopener\">cr\u00e9er une boucle en code C#<\/a>, bas\u00e9e sur le temps. De la m\u00eame mani\u00e8re, avec le composant SSIS Script Task, il est possible d&rsquo;utiliser les fonctions de temps pour param\u00e9trer la pause et attendre le temps souhait\u00e9.<\/p>\n\n\n\n<p>Toutefois une solution encode plus simple est d&rsquo;utiliser la t\u00e2che <strong><em>Execute SQL Task<\/em><\/strong> et la fonction T-SQL WAITFOR DELAY. Ou encore de programmer le moment auquel le package doit \u00eatre finir son ex\u00e9cution. Cette page liste tous les tutoriels pour <a href=\"https:\/\/expert-only.com\/tutoriels-ssis\/\">apprendre les bases de Microsoft SSIS<\/a>. <\/p>\n\n\n\n<p>Voici un exemple de <a href=\"https:\/\/fr.wiktionary.org\/wiki\/T-SQL\" target=\"_blank\" rel=\"noreferrer noopener\">script Transact-SQL<\/a> pour ajouter simplement une pause de quelques secondes, minutes ou quelques heures avant de passer au composant suivant. Il permet par exemple d&rsquo;attendre qu&rsquo;une copie de fichiers ou de chargement se finisse totalement. Pour cela, param\u00e9trer les heures, les minutes et les secondes directement dans le code SQL ou en dur dans une variable SSIS.<\/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\/creer-une-pause-dans-un-package-ssis\/#1-ajouter-et-parametrer-les-composant-ssis\" >1. Ajouter et param\u00e9trer les composant SSIS<\/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\/creer-une-pause-dans-un-package-ssis\/#2-configurer-la-tache-ssis-dexecution-de-code-sql\" >2. Configurer la t\u00e2che SSIS d&rsquo;ex\u00e9cution de code SQL<\/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\/creer-une-pause-dans-un-package-ssis\/#3-executer-le-package-ssis-et-observer-le-temps-de-pause\" >3. Ex\u00e9cuter le package SSIS et observer le temps de pause<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#conclusion-sur-les-pauses-dans-les-packages-ssis\" >Conclusion sur les pauses dans les packages SSIS<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-ajouter-et-parametrer-les-composant-ssis\"><\/span>1. Ajouter et param\u00e9trer les composant SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour commencer, <a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">cr\u00e9er un projet SSIS avec Visual Studio 2019<\/a>. Ensuite, <a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-connexion-base-sql-server-ssis\/\">configurer une connexion OLE DB vers une base de donn\u00e9es SQL Server<\/a>, ici c&rsquo;est une base locale et c&rsquo;est donc <em>localhost<\/em> qui est utilis\u00e9 comme serveur. Puis ajouter les composants suivants : <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Un premier flux de donn\u00e9es.<\/li>\n\n\n\n<li>Le composant <em><strong>Execute SQL Task<\/strong><\/em> (Ex\u00e9cution de t\u00e2che SQL) entre les deux flux de donn\u00e9es pour temporiser l&rsquo;ex\u00e9cution.<\/li>\n\n\n\n<li>Le deuxi\u00e8me flux de donn\u00e9es SSIS.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_ajout_execute_sql_task-1.jpg\" alt=\"Ajouter une t\u00e2che SQL pour cr\u00e9er une pause dans un package SSIS\" class=\"wp-image-8102\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_ajout_execute_sql_task-1.jpg 601w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_ajout_execute_sql_task-1-300x290.jpg 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><figcaption class=\"wp-element-caption\"><em>Ajouter une t\u00e2che SQL pour cr\u00e9er une pause dans un package SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-configurer-la-tache-ssis-dexecution-de-code-sql\"><\/span>2. Configurer la t\u00e2che SSIS d&rsquo;ex\u00e9cution de code SQL <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Configurer le composant avec une requ\u00eate T-SQL pour attendre le temps souhait\u00e9, avec un format de type : <strong><em>HH:MM:SS<\/em><\/strong>, dans cet ordre : <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Heures<\/li>\n\n\n\n<li>Minutes<\/li>\n\n\n\n<li>Secondes<\/li>\n<\/ul>\n\n\n\n<p>Utiliser cet exemple de code SQL pour cr\u00e9er une pause de 5 secondes avec un script T-SQL.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">WAITFOR DELAY '00:00:05'; \n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"673\" height=\"591\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execute_sql_task.jpg\" alt=\"S\u00e9lectionner la base et ajouter le code SQL pour cr\u00e9er une pause de 5 secondes\" class=\"wp-image-8108\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execute_sql_task.jpg 673w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execute_sql_task-300x263.jpg 300w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><figcaption class=\"wp-element-caption\"><em>S\u00e9lectionner la base et ajouter le code SQL pour cr\u00e9er une pause de 5 secondes<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-executer-le-package-ssis-et-observer-le-temps-de-pause\"><\/span>3. Ex\u00e9cuter le package SSIS et observer le temps de pause<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une fois la pause en place, ex\u00e9cuter le package contenant les flux de donn\u00e9es et observer le temps de pause de 5 secondes.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"587\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execution_5_secondes_delai.jpg\" alt=\"Le package SSIS fait une pause de 5 secondes puis passe \u00e0 la t\u00e2che suivante\" class=\"wp-image-8117\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execution_5_secondes_delai.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execution_5_secondes_delai-300x294.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\">Le package SSIS fait une pause de 5 secondes puis passe \u00e0 la t\u00e2che suivante<\/figcaption><\/figure><\/div>\n\n\n<p>Une fois la pause termin\u00e9e, les t\u00e2ches suivantes s&rsquo;ex\u00e9cutent normalement. Il est \u00e9galement possible de g\u00e9rer ce script \u00e9galement avec des <strong><a href=\"https:\/\/expert-only.com\/transact-sql\/executer-une-requete-sql-server-avec-une-variable-en-dur\/\">variables<\/a><\/strong> SSIS pour plus de flexibilit\u00e9.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"584\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execution_terminee.jpg\" alt=\"Fin d'ex\u00e9cution avec succ\u00e8s du package SSIS avec une pause\" class=\"wp-image-8123\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execution_terminee.jpg 601w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/06\/ssis_pause_execution_terminee-300x292.jpg 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><figcaption class=\"wp-element-caption\">Fin d&rsquo;ex\u00e9cution avec succ\u00e8s du package SSIS avec une pause<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion-sur-les-pauses-dans-les-packages-ssis\"><\/span>Conclusion sur les pauses dans les packages SSIS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Utiliser un script SQL Server est le moyen le plus simple d&rsquo;impl\u00e9menter une pause dans un package SSIS. Il ne permet pas de r\u00e9gler les besoins plus complexes comme attendre le d\u00e9p\u00f4t d&rsquo;un fichier texte par exemple. Mais le script peut \u00eatre utilis\u00e9 dans une boucle avec des contraintes de pr\u00e9c\u00e9dence et des variables pour parvenir \u00e0 la solution.<\/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\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"A0Xldyl8UC\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/executer-package-ssis-ligne-de-commande\/\">Ex\u00e9cuter un package SSIS en ligne de commande avec DTExec<\/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\u00a0Ex\u00e9cuter un package SSIS en ligne de commande avec DTExec\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/executer-package-ssis-ligne-de-commande\/embed\/#?secret=ZuSaiQI9Am#?secret=A0Xldyl8UC\" data-secret=\"A0Xldyl8UC\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Autres tutoriels sur la gestion des packages SSIS<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/ssis\/executer-un-package-ssis-avec-ms-dos-et-dtexec\/\">Ex\u00e9cuter les packages SSIS en ligne de commande avec MS-DOS<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/deployer-un-package-ssis-en-cmd\/\">D\u00e9ployer un package SSIS avec Windows CMD<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/ssis\/planifier-des-packages-ssis-avec-sql-server\/\">Planifier des packages SSIS avec l&rsquo;agent SQL Server<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Cr\u00e9er une pause dans un package SSIS avec une requ\u00eate T-SQL et la fonction WAIT FOR DELAY. L\u2019ETL SSIS de Microsoft ne propose pas de composant natif d\u00e9di\u00e9 pour cr\u00e9er une pause dans un package SSIS. Qu&rsquo;elle soit de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\" title=\"Cr\u00e9er une pause dans un package SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10827,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-1291","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 une pause dans un package SSIS - Integration Services<\/title>\n<meta name=\"description\" content=\"Dans un package SSIS, cr\u00e9er une pause dans un flux de contr\u00f4le avec le composant d&#039;ex\u00e9cution de script SQL et la fonction T-SQL WAITFOR.\" \/>\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-une-pause-dans-un-package-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er une pause dans un package SSIS\" \/>\n<meta property=\"og:description\" content=\"Dans un package SSIS, cr\u00e9er une pause dans un flux de contr\u00f4le avec le composant d&#039;ex\u00e9cution de script SQL et la fonction T-SQL WAITFOR.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-08T04:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-16T11:25:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_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\/creer-une-pause-dans-un-package-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er une pause dans un package SSIS\",\"datePublished\":\"2023-05-08T04:25:00+00:00\",\"dateModified\":\"2023-05-16T11:25:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\"},\"wordCount\":636,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\",\"name\":\"Cr\u00e9er une pause dans un package SSIS - Integration Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg\",\"datePublished\":\"2023-05-08T04:25:00+00:00\",\"dateModified\":\"2023-05-16T11:25:13+00:00\",\"description\":\"Dans un package SSIS, cr\u00e9er une pause dans un flux de contr\u00f4le avec le composant d'ex\u00e9cution de script SQL et la fonction T-SQL WAITFOR.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er une pause 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":"Cr\u00e9er une pause dans un package SSIS - Integration Services","description":"Dans un package SSIS, cr\u00e9er une pause dans un flux de contr\u00f4le avec le composant d'ex\u00e9cution de script SQL et la fonction T-SQL WAITFOR.","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-une-pause-dans-un-package-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er une pause dans un package SSIS","og_description":"Dans un package SSIS, cr\u00e9er une pause dans un flux de contr\u00f4le avec le composant d'ex\u00e9cution de script SQL et la fonction T-SQL WAITFOR.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-08T04:25:00+00:00","article_modified_time":"2023-05-16T11:25:13+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_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\/creer-une-pause-dans-un-package-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er une pause dans un package SSIS","datePublished":"2023-05-08T04:25:00+00:00","dateModified":"2023-05-16T11:25:13+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/"},"wordCount":636,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/","name":"Cr\u00e9er une pause dans un package SSIS - Integration Services","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg","datePublished":"2023-05-08T04:25:00+00:00","dateModified":"2023-05-16T11:25:13+00:00","description":"Dans un package SSIS, cr\u00e9er une pause dans un flux de contr\u00f4le avec le composant d'ex\u00e9cution de script SQL et la fonction T-SQL WAITFOR.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pocket-watch-on-black-46ECE144EB3_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/creer-une-pause-dans-un-package-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er une pause 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\/1291","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=1291"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1291\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10827"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}