{"id":1284,"date":"2024-03-08T07:44:26","date_gmt":"2024-03-08T06:44:26","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1284"},"modified":"2024-03-08T18:45:33","modified_gmt":"2024-03-08T17:45:33","slug":"se-connecter-a-une-base-de-donnees-sql-server-avec-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/","title":{"rendered":"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Tutoriel pas \u00e0 pas pour cr\u00e9er une connexion \u00e0 une base de donn\u00e9es SQL Server depuis un package SSIS.<\/em><\/h4>\n\n\n\n<p>Pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS, il est n\u00e9cessaire et recommand\u00e9 d&rsquo;utiliser le gestionnaire de connexions. Surtout pour les d\u00e9butants dans le d\u00e9veloppement de flux de donn\u00e9es. Il est \u00e9galement possible d&rsquo;utiliser des variables pour g\u00e9rer les cha\u00eenes de connexion de fa\u00e7on dynamique, mais il s&rsquo;agit d&rsquo;un sujet avanc\u00e9 qui sera trait\u00e9 dans un autre tutoriel. Il existe diff\u00e9rents types de connexions, comme les connexions OLE DB, ODBC, Fichiers plats, ADO, Analysis Services (OLAP), XML, Excel, Azure, FTP, HTTP, etc.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Un pr\u00e9requis: cr\u00e9er un projet SSIS<\/strong><\/h5>\n\n\n\n<p id=\"h-comment-creer-une-connexion-a-une-base-de-donnees-depuis-le-connection-manager-avec-ssis\">Ce tutoriel explique, \u00e9tape par \u00e9tape comment cr\u00e9er une connexion \u00e0 une base de donn\u00e9es MS SQL depuis un package Integration Services, pour importer ou exporter depuis la base source vers une cible. Tout d&rsquo;abord, le tutoriel pr\u00e9c\u00e9dent explique <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-projet-ssis-avec-visual-studio-2019\/\">comment cr\u00e9er pas \u00e0 pas un projet SSIS avec Visual Studio 2019<\/a> et y ajouter un nouveau package, c&rsquo;est \u00e0 dire un fichier une extension dtsx.<\/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=\"eJEoUkFcrC\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-projet-ssis-avec-visual-studio\/\">Comment cr\u00e9er un projet et une solution SSIS avec Visual Studio ?<\/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\u00a0Comment cr\u00e9er un projet et une solution SSIS avec Visual Studio ?\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-projet-ssis-avec-visual-studio\/embed\/#?secret=Cor3oQPh96#?secret=eJEoUkFcrC\" data-secret=\"eJEoUkFcrC\" 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-1-utiliser-le-gestionnaire-de-connexion-ssis-pour-se-connecter-a-sql-server\">1. Utiliser le gestionnaire de connexion SSIS pour se connecter \u00e0 SQL Server<\/h2>\n\n\n\n<p id=\"h-comment-creer-une-connexion-a-une-base-de-donnees-depuis-le-connection-manager-avec-ssis\">Premi\u00e8rement, utiliser la zone <em>Connection Managers<\/em> (gestionnaire de connexion en Fran\u00e7ais) ouverte par d\u00e9faut \u00e0 l&rsquo;ouverture du package <a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_Server_Integration_Services\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS<\/a>. Cette zone se trouve en bas de l&rsquo;\u00e9cran dans <a href=\"https:\/\/expert-only.com\/fr\/ssis\/installer-ssis-visual-studio-2019\/\">Visual Studio 2019<\/a> ou 2022. Il est possible de cr\u00e9er diff\u00e9rents types de connexions pour utiliser des sources de donn\u00e9es h\u00e9t\u00e9rog\u00e8nes, comme ci-dessous. Dans ce cas, c&rsquo;est <em>New OLE DB Connection<\/em> pour cr\u00e9er une connexion avec le driver recommand\u00e9 pour les connections directes aux bases de donn\u00e9es SQL Server. Suivre simplement les quelques \u00e9tapes ci-dessous:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><em>Ouvrir<\/em> un package SSIS depuis l&rsquo;explorateur de solution.<\/li>\n\n\n\n<li>Faire un <em>clic-droit<\/em> dans la zone <em>Connection Managers<\/em>.<\/li>\n\n\n\n<li>Choisir <em>New OLE DB Connection<\/em>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"446\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis.jpg\" alt=\"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS\" class=\"wp-image-11318\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis.jpg 724w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis-300x185.jpg 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><figcaption class=\"wp-element-caption\"><em>Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>A l&rsquo;\u00e9cran de configuration, s\u00e9lectionner ensuite <em>Ne<\/em>w :<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"513\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/add-new-data-connection-ole-db-connection-manager.jpg\" alt=\"Nouvelle connexion OLE DB depuis SSIS\" class=\"wp-image-11323\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/add-new-data-connection-ole-db-connection-manager.jpg 590w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/add-new-data-connection-ole-db-connection-manager-300x261.jpg 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><figcaption class=\"wp-element-caption\"><em>Nouvelle connexion OLE DB depuis SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">2. Configurer la connexion \u00e0 la base de donn\u00e9es SQL Server<\/h2>\n\n\n\n<p>Deuxi\u00e8mement, il suffit maintenant de renseigner les options de connexions \u00e0 la base de donn\u00e9es SQL Server.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Entrer le nom du serveur de base de donn\u00e9es, <strong><em>localhost<\/em> <\/strong>dans l&rsquo;exemple, car c&rsquo;est une base locale.<\/li>\n\n\n\n<li>Le type d&rsquo;authentification, ici c&rsquo;est <strong><em>Windows Authentication<\/em>.<\/strong><\/li>\n\n\n\n<li>Et choisir la base de donn\u00e9es, ici c&rsquo;est <strong><em>Expert-Only<\/em>.<\/strong><\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"712\" height=\"645\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis.jpg\" alt=\"Configurer la connexion \u00e0 la base de donn\u00e9es SQL Server\" class=\"wp-image-11328\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis.jpg 712w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis-300x272.jpg 300w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><figcaption class=\"wp-element-caption\"><em>Configurer la connexion \u00e0 la base de donn\u00e9es SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">3. Tester la connectivit\u00e9 \u00e0 la base de donn\u00e9es<\/h2>\n\n\n\n<p>Tester ensuite la connexion pour v\u00e9rifier la connectivit\u00e9. Il est recommand\u00e9 de tester la connexion au plus t\u00f4t pour \u00e9viter les erreurs lors du d\u00e9veloppement de vos packages Integration Services.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"160\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-test-connection-manager.jpg\" alt=\"Le test de connexion \u00e0 la base SQL Server est r\u00e9ussi\" class=\"wp-image-11354\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-test-connection-manager.jpg 709w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-test-connection-manager-300x68.jpg 300w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><figcaption class=\"wp-element-caption\"><em>Le test de connexion \u00e0 la base SQL Server est r\u00e9ussi<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-propos-de-la-connectivite-ssis-avec-les-bases-de-donnees-sql-server\">A propos de la connectivit\u00e9 SSIS avec les bases de donn\u00e9es SQL Server<\/h3>\n\n\n\n<p>La suite logique est de <a href=\"https:\/\/expert-only.com\/ssis\/creer-un-data-flow-ssis-simple\/\">cr\u00e9er un flux de donn\u00e9es simple \u00e0 l&rsquo;int\u00e9rieur du flux de contr\u00f4le SSIS<\/a>. En g\u00e9n\u00e9ral, l&rsquo;objectif d&rsquo;un package ETL est de transf\u00e9rer et \u00e9ventuellement de transformer des donn\u00e9es d&rsquo;une source \u00e0 une cible. Voici un autre tutoriel pour r\u00e9soudre un probl\u00e8me typique d&rsquo;int\u00e9gration de donn\u00e9es Excel avec SSIS, c&rsquo;est-\u00e0-dire comment g\u00e9rer le type de donn\u00e9es Excel dans un package.<\/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=\"VaXHQD2nyK\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/\">Cr\u00e9er un data flow SSIS simple<\/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\u00a0Cr\u00e9er un data flow SSIS simple\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/creer-un-data-flow-ssis-simple\/embed\/#?secret=VpJyiS0R4V#?secret=VaXHQD2nyK\" data-secret=\"VaXHQD2nyK\" 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>Tutoriel pas \u00e0 pas pour cr\u00e9er une connexion \u00e0 une base de donn\u00e9es SQL Server depuis un package SSIS. Pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS, il est n\u00e9cessaire et recommand\u00e9 d&rsquo;utiliser <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\" title=\"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10797,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-1284","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>Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS - ETL<\/title>\n<meta name=\"description\" content=\"Tutoriel pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS et le gestionnaire de connexions.\" \/>\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\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS\" \/>\n<meta property=\"og:description\" content=\"Tutoriel pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS et le gestionnaire de connexions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-08T06:44:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-08T17:45:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_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\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS\",\"datePublished\":\"2024-03-08T06:44:26+00:00\",\"dateModified\":\"2024-03-08T17:45:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\"},\"wordCount\":597,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\",\"name\":\"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS - ETL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"datePublished\":\"2024-03-08T06:44:26+00:00\",\"dateModified\":\"2024-03-08T17:45:33+00:00\",\"description\":\"Tutoriel pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS et le gestionnaire de connexions.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec 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":"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS - ETL","description":"Tutoriel pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS et le gestionnaire de connexions.","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\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS","og_description":"Tutoriel pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS et le gestionnaire de connexions.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-08T06:44:26+00:00","article_modified_time":"2024-03-08T17:45:33+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_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\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS","datePublished":"2024-03-08T06:44:26+00:00","dateModified":"2024-03-08T17:45:33+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/"},"wordCount":597,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/","name":"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec SSIS - ETL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","datePublished":"2024-03-08T06:44:26+00:00","dateModified":"2024-03-08T17:45:33+00:00","description":"Tutoriel pour se connecter \u00e0 une base de donn\u00e9es SQL Server avec un package SSIS et le gestionnaire de connexions.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/se-connecter-a-une-base-de-donnees-sql-server-avec-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Se connecter \u00e0 une base de donn\u00e9es SQL Server avec 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\/1284","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=1284"}],"version-history":[{"count":3,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1284\/revisions"}],"predecessor-version":[{"id":30602,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1284\/revisions\/30602"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10797"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}