{"id":1069,"date":"2022-03-31T06:40:00","date_gmt":"2022-03-31T04:40:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1069"},"modified":"2023-05-15T12:44:01","modified_gmt":"2023-05-15T10:44:01","slug":"detecter-type-donnees-excel-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/","title":{"rendered":"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS"},"content":{"rendered":"\n<p class=\"has-text-align-center\"><strong><em>D\u00e9tecter le type de donn\u00e9es des colonnes Excel avec SSIS et \u00e9viter les erreurs d&rsquo;int\u00e9gration<\/em><\/strong>.<\/p>\n\n\n\n<p>L&rsquo;int\u00e9gration des fichiers Excel via SSIS vous oblige \u00e0 figer le type de donn\u00e9es dans le composant OLEDB.&nbsp;En effet, le type de donn\u00e9es Excel est d\u00e9termin\u00e9 dans SSIS par un \u00e9chantillonnage des 8 premi\u00e8res lignes. Et ce depuis la colonne par d\u00e9faut dans le composant OLEDB pour les sources Excel. Donc, le but est d\u2019int\u00e9grer un fichier avec le format qui correspond \u00e0 la source. Il vous faudra faire en sorte que les premi\u00e8res lignes du fichier soient dans un type compatible.<\/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\/detecter-type-donnees-excel-ssis\/#ssis-detecte-le-type-des-colonnes-excel-par-echantillonnage\" >SSIS d\u00e9tecte le type des colonnes Excel par \u00e9chantillonnage<\/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\/detecter-type-donnees-excel-ssis\/#erreurs-de-chargements-de-fichiers-excel-avec-ssis\" >Erreurs de chargements de fichiers Excel avec 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\/detecter-type-donnees-excel-ssis\/#erreur-dintegration-dune-colonne-excel-mixte-avec-texte-et-chiffres\" >Erreur d&rsquo;int\u00e9gration d&rsquo;une colonne Excel mixte avec texte et chiffres<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ssis-detecte-le-type-des-colonnes-excel-par-echantillonnage\"><\/span>SSIS d\u00e9tecte le type des colonnes Excel par \u00e9chantillonnage<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Notez que par d\u00e9faut, le nombre de lignes \u00e9chantillonn\u00e9es est de 8. Il est toutefois possible de modifier le nombre de lignes \u00e9chantillonn\u00e9es par le driver Excel. En effet, pour changer le nombre de lignes \u00e9chantillonn\u00e9es par <a href=\"https:\/\/expert-only.com\/astuces-excel\/telecharger-driver-oledb-pour-excel-2010\/\">le driver Excel Access Database Engine 12.0<\/a>, changer la clef de registre comme ci-dessous:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ouvrir l&rsquo;\u00e9diteur de registre, pour ce faire, aller dans le <strong>menu d\u00e9marrer<\/strong>, taper <strong>regedit<\/strong>.<\/li>\n\n\n\n<li>Rendez vous dans sur une de ces clefs de registres, elle d\u00e9pend de votre installation et du driver utiliser pour lire les fichiers Excel:<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Jet\\4.0\\Engines\\Excel<\/strong><\/li>\n\n\n\n<li><strong>HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Office\\16.0\\Access Connectivity Engine\\Engines\\Excel<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Changer ensuite la valeur de la clef appel\u00e9e <b>TypeGuessRows<\/b>. Vous pouvez entrer des valeurs pour TypeGuessRows uniquement comprises <strong>entre 0 \u00e0 16 en d\u00e9cimal<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"510\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling.jpg\" alt=\"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS\" class=\"wp-image-25499\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling.jpg 934w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling-300x164.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/05\/ssis_excel_regedit_typeguessrows_sampling-768x419.jpg 768w\" sizes=\"auto, (max-width: 934px) 100vw, 934px\" \/><figcaption class=\"wp-element-caption\"><em>D\u00e9tecter le type de donn\u00e9es Excel avec SSIS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-erreurs-de-chargements-de-fichiers-excel-avec-ssis\"><span class=\"ez-toc-section\" id=\"erreurs-de-chargements-de-fichiers-excel-avec-ssis\"><\/span>Erreurs de chargements de fichiers Excel avec SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8rement, l&rsquo;erreur la plus r\u00e9currente est de tenter d&rsquo;int\u00e9grer un fichier <a href=\"https:\/\/en.wiktionary.org\/wiki\/Excel\" target=\"_blank\" rel=\"noreferrer noopener\">Excel<\/a> ayant des colonnes avec des cha\u00eenes sup\u00e9rieures \u00e0 255 caract\u00e8res. Par exemple, les lignes \u00e9chantillonn\u00e9es ne contiennent aucune cha\u00eene avec une longueur sup\u00e9rieure \u00e0 255 caract\u00e8res. Alors le type de donn\u00e9es d\u00e9tect\u00e9 par SSIS dans le fichier Excel qui sera assign\u00e9 \u00e0 la colonne est : <strong>DT_WSTR(255) et non pas N_TEXT<\/strong>. De plus, la totalit\u00e9 des lignes avec une longueur sup\u00e9rieure \u00e0 255 caract\u00e8res seront tronqu\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"erreur-dintegration-dune-colonne-excel-mixte-avec-texte-et-chiffres\"><\/span>Erreur d&rsquo;int\u00e9gration d&rsquo;une colonne Excel mixte avec texte et chiffres<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une autre erreur classique lorsque vous int\u00e9grez des fichiers Excel est la d\u00e9tection du type <strong>DT_NUMERIC<\/strong> au lieu du type <strong>DT_WSTR<\/strong>. Par exemple, si la colonne Excel contient des centaines ou des milliers de lignes. Avec des chiffres et des caract\u00e8res, mais que les 16 premi\u00e8res lignes ne contiennent que des valeurs num\u00e9riques. Le syst\u00e8me SSIS l&rsquo;interpr\u00e8te alors comme une colonne num\u00e9rique.<\/p>\n\n\n\n<p>C&rsquo;est tout pour ce tutoriel technique sur la fa\u00e7on de d\u00e9tecter le type de donn\u00e9es Excel avec SSIS en modifiant l&rsquo;\u00e9chantillonange via l&rsquo;\u00e9diteur de registre de Windows.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Autres ressources sur l&rsquo;int\u00e9gration de donn\u00e9es Excel depuis SSIS<\/h3>\n\n\n\n<p>Le tutoriel SSIS ci-dessous explique <a href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-excel-avec-ssis\/\">comment charger un fichier Excel dans une base de donn\u00e9es SQL Server avec un package SSIS<\/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=\"A5dzeJAYb2\"><a href=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-excel-avec-ssis\/\">Importer un fichier Excel avec SSIS dans une base 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\u00a0Importer un fichier Excel avec SSIS dans une base SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/ssis\/importer-un-fichier-excel-avec-ssis\/embed\/#?secret=6zDGcLnMGI#?secret=A5dzeJAYb2\" data-secret=\"A5dzeJAYb2\" 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>D\u00e9tecter le type de donn\u00e9es des colonnes Excel avec SSIS et \u00e9viter les erreurs d&rsquo;int\u00e9gration. L&rsquo;int\u00e9gration des fichiers Excel via SSIS vous oblige \u00e0 figer le type de donn\u00e9es dans le composant OLEDB.&nbsp;En effet, le type de donn\u00e9es Excel <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/\" title=\"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10817,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":{"0":"post-1069","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>D\u00e9tecter le type de donn\u00e9es Excel avec SSIS avant import - MS BI<\/title>\n<meta name=\"description\" content=\"Pour d\u00e9tecter le type de donn\u00e9es Excel \u00e0 importer avec SSIS, changer le nombre de ligne utilis\u00e9es pour l&#039;\u00e9chantillonage du fichier source.\" \/>\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\/detecter-type-donnees-excel-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS\" \/>\n<meta property=\"og:description\" content=\"Pour d\u00e9tecter le type de donn\u00e9es Excel \u00e0 importer avec SSIS, changer le nombre de ligne utilis\u00e9es pour l&#039;\u00e9chantillonage du fichier source.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-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=\"2022-03-31T04:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-15T10:44:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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=\"3 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\/detecter-type-donnees-excel-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS\",\"datePublished\":\"2022-03-31T04:40:00+00:00\",\"dateModified\":\"2023-05-15T10:44:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/\"},\"wordCount\":531,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/\",\"name\":\"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS avant import - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"datePublished\":\"2022-03-31T04:40:00+00:00\",\"dateModified\":\"2023-05-15T10:44:01+00:00\",\"description\":\"Pour d\u00e9tecter le type de donn\u00e9es Excel \u00e0 importer avec SSIS, changer le nombre de ligne utilis\u00e9es pour l'\u00e9chantillonage du fichier source.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9tecter le type de donn\u00e9es Excel 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":"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS avant import - MS BI","description":"Pour d\u00e9tecter le type de donn\u00e9es Excel \u00e0 importer avec SSIS, changer le nombre de ligne utilis\u00e9es pour l'\u00e9chantillonage du fichier source.","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\/detecter-type-donnees-excel-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS","og_description":"Pour d\u00e9tecter le type de donn\u00e9es Excel \u00e0 importer avec SSIS, changer le nombre de ligne utilis\u00e9es pour l'\u00e9chantillonage du fichier source.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-03-31T04:40:00+00:00","article_modified_time":"2023-05-15T10:44:01+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS","datePublished":"2022-03-31T04:40:00+00:00","dateModified":"2023-05-15T10:44:01+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/"},"wordCount":531,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/","name":"D\u00e9tecter le type de donn\u00e9es Excel avec SSIS avant import - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","datePublished":"2022-03-31T04:40:00+00:00","dateModified":"2023-05-15T10:44:01+00:00","description":"Pour d\u00e9tecter le type de donn\u00e9es Excel \u00e0 importer avec SSIS, changer le nombre de ligne utilis\u00e9es pour l'\u00e9chantillonage du fichier source.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/planning-4897792_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/detecter-type-donnees-excel-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9tecter le type de donn\u00e9es Excel 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\/1069","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=1069"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1069\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10817"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}