{"id":1136,"date":"2022-05-19T06:04:00","date_gmt":"2022-05-19T04:04:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1136"},"modified":"2022-09-19T18:36:33","modified_gmt":"2022-09-19T16:36:33","slug":"liste-des-erreurs-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/","title":{"rendered":"Liste de toutes les erreurs SSIS"},"content":{"rendered":"\n<p>Voici la liste de tous les codes erreurs SSIS. Les erreurs SSIS sont souvent nombreuses et parfois, se r\u00e9v\u00e8lent difficiles \u00e0 interpr\u00e9ter, que ce soit en lan\u00e7ant les packages SSIS via l&rsquo;Agent SQL Server, depuis une ligne de commande gr\u00e2ce \u00e0 la commande dtexec.exe ou encore depuis Visual Studio 2017 ou 2019. <\/p>\n\n\n\n<p>Ce modeste article expose simplement la liste de toutes les erreurs SSIS que les d\u00e9veloppeurs SSIS vont tr\u00e8s bien connaitre, surtout au d\u00e9but de leur apprentissage. Pour rappel, SSIS est disponible pour Visual Studio 2017, Visual Studio 2019 et maintenant pour Visual Studio 2022.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-liste-toutes-les-codes-d-erreurs-ssis\">Liste toutes les codes d&rsquo;erreurs SSIS<\/h2>\n\n\n\n<p>En effet, une fois confirm\u00e9s, les d\u00e9veloppeurs Microsoft SSIS qui l&rsquo;utilisent pour int\u00e9grer des donn\u00e9es ne se r\u00e9f\u00e8rent plus au site officiel de Microsoft car toutes les erreurs reviennent et sont, pour la plupart, connues.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Acc\u00e9l\u00e9rer le d\u00e9veloppement et la gestion des erreurs avec Integration Services<\/h3>\n\n\n\n<p>D&rsquo;autre part, cette liste des erreurs est tr\u00e8s pratique comme aide-m\u00e9moire et aide au d\u00e9bogage des packages SSIS.<\/p>\n\n\n\n<p>En cas d&rsquo;erreur, un&nbsp;message d&rsquo;erreur SSIS&nbsp;plus ou moins explicite est \u00e9crit dans <strong><a href=\"https:\/\/expert-only.com\/ssis\/configurer-gestion-logs-microsoft-ssis-2008\/\">le journal de log qui trace l&rsquo;ex\u00e9cution du package SSIS<\/a><\/strong>&nbsp;(fichier .dtsx bas\u00e9 sur du XML), ce qui rend possible au d\u00e9veloppeur de d\u00e9bugger le package. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Les diff\u00e9rents types d&rsquo;erreurs rencontr\u00e9es avec Integration Services<\/h3>\n\n\n\n<p>Voici la liste compl\u00e8te des erreurs retourn\u00e9es par&nbsp;SSIS&nbsp;comprenant les&nbsp;erreurs SSIS&nbsp;de types :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Messages d&rsquo;erreur avec le pr\u00e9fixe DTS_E_* :&nbsp;<a href=\"http:\/\/technet.microsoft.com\/fr-fr\/library\/ms345164.aspx#msgError\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/technet.microsoft.com\/fr-fr\/libra&#8230;x#msgError<\/a><\/li><li>Messages d&rsquo;avertissement ou warnings avec le pr\u00e9fixe DTS_W_*:&nbsp;<a href=\"http:\/\/technet.microsoft.com\/fr-fr\/library\/ms345164.aspx#msgWarning\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/technet.microsoft.com\/fr-fr\/libra&#8230;msgWarning<\/a><\/li><li>Messages d&rsquo;information avec le pr\u00e9fixe DTS_I_* :&nbsp;<a href=\"http:\/\/technet.microsoft.com\/fr-fr\/library\/ms345164.aspx#msgInfo\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/technet.microsoft.com\/fr-fr\/libra&#8230;px#msgInfo<\/a><\/li><li>Messages g\u00e9n\u00e9raux et d&rsquo;\u00e9v\u00e9nement avec le pr\u00e9fixe DTS_MSG_*:&nbsp;<a href=\"http:\/\/technet.microsoft.com\/fr-fr\/library\/ms345164.aspx#msgGeneral\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/technet.microsoft.com\/fr-fr\/libra&#8230;msgGeneral<\/a><\/li><li>Messages de r\u00e9ussite avec le pr\u00e9fixe DTS_S_* :&nbsp;<a href=\"http:\/\/technet.microsoft.com\/fr-fr\/library\/ms345164.aspx#msgSuccess\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/technet.microsoft.com\/fr-fr\/libra&#8230;msgSuccess<\/a><\/li><li>Messages d&rsquo;erreur des composants de flux de donn\u00e9es avec le pr\u00e9fixe DTSBC_E_* :&nbsp;<a href=\"http:\/\/technet.microsoft.com\/fr-fr\/library\/ms345164.aspx#msgPipeline\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/technet.microsoft.com\/fr-fr\/libra&#8230;sgPipeline<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Les erreurs fr\u00e9quentes d&rsquo;int\u00e9gration avec SSIS<\/h3>\n\n\n\n<p id=\"h-les-messages-uniques-individuels-suivants-que-l-ont-rencontre-souvent-sont-plutot-lies-a-sql-server-qu-au-composant-ssis\">Les messages uniques individuels suivants sont fr\u00e9quents et plut\u00f4t li\u00e9s \u00e0 SQL Server qu&rsquo;au composant SSIS lui-m\u00eame. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Tout d&rsquo;abord, une erreur des plus fr\u00e9quentes: <strong>DTS_E_OLEDBERROR<\/strong> ou <strong>0x80040E4D<\/strong> : DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: <strong>0x80040E4D<\/strong>. An OLE DB record is available. Source: Microsoft SQL Native Client Hresult: 0x80040E4D Description: Login failed for user . Symbolic Name: <strong>DTS_E_OLEDBERROR<\/strong>. The hexadecimal value for this error number = 0x80040E4D.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Le message d&rsquo;erreur SQL Server &#8211; <strong>2068578304<\/strong>: Echec lors de l&rsquo;installation de SQL Server 2008 R2 SP1 car le mot de passe sa n&rsquo;est pas assez fort.<\/li><li>Ensuite, le message d&rsquo;erreur sql server &#8211; <strong>2068643839<\/strong>: Mise \u00e0 jour en SP2 par Windows Update de MSXML6.<\/li><li>Message d&rsquo;erreur sql server &#8211;<strong>2146232060<\/strong>&nbsp;: Erreur lors de la connexion au serveur ACT 5.6 dans la console SCCM en R3 avec le connecteur.<\/li><li>Ou encore le message d&rsquo;erreur sql server &#8211;<strong>2146885628<\/strong>: SP2 a \u00e9chou\u00e9 uniquement sur \u200b\u200ble moteur de base de donn\u00e9es, le service MSSQLSERVER ne peut pas d\u00e9marrer.<\/li><li>Enfin, le message d&rsquo;erreur sql server &#8211;<strong>2147217900<\/strong>: Quand vous vous servez du serveur li\u00e9 dans SQL Server afin d&rsquo;ex\u00e9cuter une proc\u00e9dure stock\u00e9e \u00e0 partir de Microsoft Transaction Server.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Les codes d&rsquo;erreur affich\u00e9s dans les packages DTSX<\/h3>\n\n\n\n<p id=\"h-enfin-voici-la-liste-complete-des-erreurs-ssis-avec-le-prefixe-dts-e-pour-error-par-ordre-alphabetique-rencontres-durant-le-developpement-de-packages-ssis\">Enfin voici la liste compl\u00e8te des erreurs SSIS avec le pr\u00e9fixe DTS_E_ pour Error, par ordre alphab\u00e9tique, rencontr\u00e9s durant le d\u00e9veloppement&nbsp;de packages SSIS avec Visual Studio ou encore lors de l&rsquo;ex\u00e9cution des packages sur un serveur depuis un batch.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>DTS_E_64BITVARIABLERECAST<\/li><li>DTS_E_ADOSRCUNKNOWNTYPEMAPPEDTONTEXT<\/li><li>DTS_E_ALREADYADDED<\/li><li>DTS_E_BEGINTRANSACTION<\/li><li>DTS_E_BPDUPLICATE<\/li><li>DTS_E_BPUNKNOWNID<\/li><li>DTS_E_CANNOTCLONECONNECTIONMANAGER<\/li><li>DTS_E_CANNOTLOADOLDPACKAGES<\/li><li>DTS_E_CANTACCESSARRAYDATA<\/li><li>DTS_E_CANTADDREMOVEWHENEXECUTING<\/li><li>DTS_E_CANTCHANGEREADONLYATRUNTIME<\/li><li>DTS_E_CANTCREATECERTCONTEXT<\/li><li>DTS_E_CANTDETERMINEWHICHPROPTOPERSIST<\/li><li>DTS_E_CANTFINDCERTBYHASH<\/li><li>DTS_E_CANTFINDCERTBYNAME<\/li><li>DTS_E_CANTGETCERTDATA<\/li><li>DTS_E_CANTLOADFROMNODE<\/li><li>DTS_E_CANTOPENCERTSTORE<\/li><li>DTS_E_CANTWRITETOFILE<\/li><li>DTS_E_CERTERROR<\/li><li>DTS_E_CHECKENVELOPEFAILED<\/li><li>DTS_E_CHECKPOINTFILEALREADYEXISTS<\/li><li>DTS_E_CHECKPOINTFILELOCKED<\/li><li>DTS_E_CHECKPOINTMISMATCH<\/li><li>DTS_E_CLIENTAUTH<\/li><li>DTS_E_COLLECTIONCOULDNTADD<\/li><li>DTS_E_COLLECTIONLOCKED<\/li><li>DTS_E_COLLOCKED<\/li><li>DTS_E_COMMANDDESTINATIONADAPTERSTATIC_ERRORSINCOMMAND<\/li><li>DTS_E_CONFIGFAILED<\/li><li>DTS_E_CONFIGFILEFAILEDEXPORT<\/li><li>DTS_E_CONFIGFORMATINVALID<\/li><li>DTS_E_CONFIGFORMATINVALID_PACKAGEDELIMITER<\/li><li>DTS_E_CONFIGTYPECONVERSIONFAILED<\/li><li>DTS_E_CONNECTIONMANAGERJOINTRANSACTION<\/li><li>DTS_E_CONNECTIONMANAGERQUALIFIERALREADYSET<\/li><li>DTS_E_CONNECTIONMANAGERQUALIFIERNOTSET<\/li><li>DTS_E_CONNECTIONMANAGERQUALIFIERNOTSUPPORTED<\/li><li>DTS_E_CONNECTIONNOTFOUND<\/li><li>DTS_E_CONNECTIONOFFLINE<\/li><li>DTS_E_CONNECTIONSTRING<\/li><li>DTS_E_CONNECTIONTERMINATED<\/li><li>DTS_E_CONNECTIONVALIDATIONFAILED<\/li><li>DTS_E_CONNECTTOSERVERFAILED<\/li><li>DTS_E_CREATECHECKPOINTFILE<\/li><li>DTS_E_CREATEFOLDERONSQLSERVER_OLEDB<\/li><li>DTS_E_CREATEMANAGEDHELPERFAILED<\/li><li>DTS_E_CUSTOMEVENTCONFLICT<\/li><li>DTS_E_DECRYPTPACKAGE_USERKEY<\/li><li>DTS_E_DECRYPTXML_PASSWORD<\/li><li>DTS_E_DISPENSEDREADONLY<\/li><li>DTS_E_DTRXMLSAVEFAILURE<\/li><li>DTS_E_DUMP_FAILED<\/li><li>DTS_E_DUPLICATECONSTRAINT<\/li><li>DTS_E_ELEMENTNOTFOUND<\/li><li>DTS_E_ERRORATLOADTASK<\/li><li>DTS_E_ERRORELEMENTNOTINCOLL<\/li><li>DTS_E_ERRORLOADINGTASK<\/li><li>DTS_E_ERRORLOADINGTASKNOCONTACT<\/li><li>DTS_E_EVENTHANDLERNOTALLOWED<\/li><li>DTS_E_EXISTSONSQLSERVER_OLEDB<\/li><li>DTS_E_EXPIRED<\/li><li>DTS_E_FAILEDDEPENDENCIES<\/li><li>DTS_E_FAILEDPOPNATIVEFEE<\/li><li>DTS_E_FAILPACKAGEONFAILURENA<\/li><li>DTS_E_FAILTOCREATEMUTEX<\/li><li>DTS_E_FAILTORELEASEMUTEX<\/li><li>DTS_E_FINDFOLDERONSQLSERVER_OLEDB<\/li><li>DTS_E_FOLDERADDFAILED<\/li><li>DTS_E_FOLDERDELETEFAILED<\/li><li>DTS_E_FOLDERNOTFOUND<\/li><li>DTS_E_FOLDERRENAMEFAILED<\/li><li>DTS_E_FORBIDDEN<\/li><li>DTS_E_FROMEXECISNOTCHILD<\/li><li>DTS_E_FTPCHANGEFOLDER<\/li><li>DTS_E_FTPCREATEFOLDER<\/li><li>DTS_E_FTPDELETEFOLDER<\/li><li>DTS_E_FTPERROR<\/li><li>DTS_E_FTPFILESEMPTY<\/li><li>DTS_E_FTPINVALIDCONNECTIONSTRING<\/li><li>DTS_E_FTPINVALIDLOCALPATH<\/li><li>DTS_E_FTPINVALIDPORT<\/li><li>DTS_E_FTPINVALIDRETRIES<\/li><li>DTS_E_FTPNOFILESTODELETE<\/li><li>DTS_E_FTPNOTCONNECTED<\/li><li>DTS_E_FUNDAMENTALLOADINGERROR<\/li><li>DTS_E_GENERICERROR<\/li><li>DTS_E_GETCONNECTIONINFOS<\/li><li>DTS_E_GETENUMERATOR<\/li><li>DTS_E_GETKEYFROMCERTFAILED<\/li><li>DTS_E_GETPACKAGEINFOS<\/li><li>DTS_E_GETXMLSOURCEFAILED<\/li><li>DTS_E_HASEMPTYTASKHOSTS<\/li><li>DTS_E_IDTSNAMENOTSUPPORTED<\/li><li>DTS_E_INVALIDARRAYVALUE<\/li><li>DTS_E_INVALIDCERTHASHFORMAT<\/li><li>DTS_E_INVALIDCHECKPOINT_TRANSACTION<\/li><li>DTS_E_INVALIDCHUNKSIZE<\/li><li>DTS_E_INVALIDFILENAMEINCONNECTION<\/li><li>DTS_E_INVALIDNODE<\/li><li>DTS_E_INVALIDPARENTPACKAGEPATH<\/li><li>DTS_E_INVALIDPATHTOPACKAGE<\/li><li>DTS_E_INVALIDSCHEME<\/li><li>DTS_E_INVALIDSERVERNAME<\/li><li>DTS_E_INVALIDSIGNATURE<\/li><li>DTS_E_INVALIDSSISSERVERNAME<\/li><li>DTS_E_INVALIDTASKPOINTER<\/li><li>DTS_E_INVALIDTIMEOUT<\/li><li>DTS_E_INVALIDURL<\/li><li>DTS_E_INVALIDVARIABLEVALUE<\/li><li>DTS_E_INVALIDVARVALUE<\/li><li>DTS_E_JAGGEDEVENTINFO<\/li><li>DTS_E_LOADFROMSQLSERVER<\/li><li>DTS_E_LOADFROMSQLSERVER_OLEDB<\/li><li>DTS_E_LOADFROMXML<\/li><li>DTS_E_LOADPACKAGEXML<\/li><li>DTS_E_LOADPACKAGEXMLFILE<\/li><li>DTS_E_LOADWININET<\/li><li>DTS_E_LOCKVARIABLEFORREAD<\/li><li>DTS_E_LOCKVARIABLEFORWRITE<\/li><li>DTS_E_LOGFAILED<\/li><li>DTS_E_LOGINFAILURE<\/li><li>DTS_E_LOGPROVIDERFAILED<\/li><li>DTS_E_MANAGEDCOMPONENTSTORENOTFOUND<\/li><li>DTS_E_MISSINGOBJECTDATA<\/li><li>DTS_E_MULTIPLECACHEWRITES<\/li><li>DTS_E_MULTIPLEFILESONRETAINEDCONNECTION<\/li><li>DTS_E_MUTEXOWNBYDIFFUSER<\/li><li>DTS_E_NAMEALREADYADDED<\/li><li>DTS_E_NAMEALREADYEXISTS<\/li><li>DTS_E_NEGATIVEINDEXNOTALLOWED<\/li><li>DTS_E_NEGATIVEVALUESNOTALLOWED<\/li><li>DTS_E_NEGATIVEVERSION<\/li><li>DTS_E_NODENOTFOUND<\/li><li>DTS_E_NOROWSETRETURNED<\/li><li>DTS_E_NOSQLPROFILERDLL<\/li><li>DTS_E_NOTDISPENSED<\/li><li>DTS_E_NOTINITIALIZED<\/li><li>DTS_E_ODBCERROR<\/li><li>DTS_E_ODBCERRORCONNECT<\/li><li>DTS_E_ODBCERRORDBC<\/li><li>DTS_E_ODBCERRORENV<\/li><li>DTS_E_ODBCTRANSACTIONENLIST<\/li><li><strong>DTS_E_OLEDBERROR<\/strong><\/li><li>DTS_E_OLEDBTRANSACTIONENLIST<\/li><li>DTS_E_OPENCERTSTORE<\/li><li>DTS_E_OPENCHECKPOINTFILE<\/li><li>DTS_E_OPENFILE<\/li><li>DTS_E_OPENLOGFAILED<\/li><li>DTS_E_OPENPACKAGEFILE<\/li><li>DTS_E_PACKAGEDESCRIPTIONTOOLONG<\/li><li>DTS_E_PACKAGELOADFAILED<\/li><li>DTS_E_PACKAGEMIGRATED<\/li><li>DTS_E_PACKAGEMIGRATIONFAILED<\/li><li>DTS_E_PACKAGEMIGRATIONMODULE<\/li><li>DTS_E_PACKAGEMIGRATIONMODULELOAD<\/li><li>DTS_E_PACKAGENAMETOOLONG<\/li><li>DTS_E_PACKAGENOTFOUND<\/li><li>DTS_E_PACKAGEOBJECTNOTENVELOPED<\/li><li>DTS_E_PACKAGEPASSWORD<\/li><li>DTS_E_PACKAGEPASSWORDEMPTY<\/li><li>DTS_E_PACKAGEPROTECT<\/li><li>DTS_E_PACKAGEREMOVEFAILED<\/li><li>DTS_E_PACKAGEUNPROTECT<\/li><li>DTS_E_PACKAGEVERIFICATIONFAILED<\/li><li>DTS_E_PERSISTENCEERROR<\/li><li>DTS_E_PRECEDENCECONSTRAINT<\/li><li>DTS_E_PROPERTIESCOLLECTIONREADONLY<\/li><li>DTS_E_PROXYAUTH<\/li><li>DTS_E_READNOTFILLEDCACHE<\/li><li>DTS_E_READUNINITIALIZEDCACHE<\/li><li>DTS_E_REDIRECTFAILURE<\/li><li>DTS_E_REMOTEPACKAGEVALIDATION<\/li><li>DTS_E_REMOVEFOLDERFROMSQLSERVER_OLEDB<\/li><li>DTS_E_REMOVEFROMSQLSERVER_OLEDB<\/li><li>DTS_E_RENAMEFOLDERONSQLSERVER_OLEDB<\/li><li>DTS_E_RESERVEDNAMESPACE<\/li><li>DTS_E_SAVEFILE<\/li><li>DTS_E_SAVEPACKAGEFILE<\/li><li>DTS_E_SAVETOSQLSERVER_OLEDB<\/li><li>DTS_E_SCRIPTMIGRATIONFAILED64BIT<\/li><li>DTS_E_SECUREFAILURE<\/li><li>DTS_E_SERVERAUTH<\/li><li>DTS_E_SERVERSTORAGEDISALLOWED<\/li><li>DTS_E_SETCACHEFORFILLFAILED<\/li><li>DTS_E_SETCACHEFORINSERTFAILED<\/li><li>DTS_E_SETCACHEFORREADFAILED<\/li><li>DTS_E_SETQUALIFIERDESIGNTIMEONLY<\/li><li>DTS_E_SIGNATURENOTPRESENT<\/li><li>DTS_E_SIGNATUREPOLICYVIOLATION<\/li><li>DTS_E_SIGNPACKAGEFAILED<\/li><li>DTS_E_SQLPERSISTENCEVERSION<\/li><li>DTS_E_SQLPROFILERDLL_ONLY_X86<\/li><li>DTS_E_SSISSTANDALONENOTINSTALLED<\/li><li>DTS_E_TASKISEMPTY<\/li><li>DTS_E_TASKPRODUCTLEVEL<\/li><li>DTS_E_TIMEOUT<\/li><li>DTS_E_TOEXECISNOTCHILD<\/li><li>DTS_E_TRANSACTIONENLISTNOTSUPPORTED<\/li><li>DTS_E_UNABLETODECODEBINARYFORMAT<\/li><li>DTS_E_UNABLETOSAVETOFILE<\/li><li>DTS_E_UNKNOWNCONNECTIONMANAGERTYPE<\/li><li>DTS_E_UNKNOWNCONNECTIONMANAGERTYPENOSUBS<\/li><li>DTS_E_UNKNOWNLOGPROVIDERTYPE<\/li><li>DTS_E_UNKNOWNLOGPROVIDERTYPENOSUBS<\/li><li>DTS_E_UNKNOWNSTATUSCODE<\/li><li>DTS_E_UNPROTECTCONNECTIONSTRINGFAILED<\/li><li>DTS_E_UNPROTECTXMLFAILED<\/li><li>DTS_E_UNSAFEVARIABLESALREADYSET<\/li><li>DTS_E_UNSUPPORTEDARRAYTYPE<\/li><li>DTS_E_UNTRUSTEDSIGNATURE<\/li><li>DTS_E_VARIABLEALREADYONREADLIST<\/li><li>DTS_E_VARIABLEALREADYONWRITELIST<\/li><li>DTS_E_VARIABLEDEADLOCK<\/li><li>DTS_E_VARIABLEDEADLOCK_BOTH<\/li><li>DTS_E_VARIABLEDEADLOCK_READ<\/li><li>DTS_E_VARIABLEDEADLOCK_READWRITE<\/li><li>DTS_E_VARIABLEINVALIDCONTAINERREF<\/li><li>DTS_E_VARIABLENOTFOUND<\/li><li>DTS_E_VARIABLENOTFOUNDINCOLL<\/li><li>DTS_E_VARIABLEREADONLY<\/li><li>DTS_E_VARIABLESALREADYUNLOCKED<\/li><li>DTS_E_VARIABLEUNLOCKFAILED<\/li><li>DTS_E_VERCOMMENTSTOOLONG<\/li><li>DTS_E_WAITFORMUTEXFAILED<\/li><li>DTS_E_WINHTTPCANNOTCONNECT<\/li><li>DTS_E_WINHTTPCERTDECODE<\/li><li>DTS_E_WINHTTPCERTENCODE<\/li><li>DTS_E_WINHTTPNOTSUPPORTED<\/li><li>DTS_E_WINHTTPOPEN<\/li><li>DTS_E_WINHTTPUNKNOWNERROR<\/li><li>DTS_E_WRITEWHILECACHEINUSE<\/li><li>DTS_E_XMLDOMERROR<\/li><li>DTS_E_XMLSRCSCHEMACOLUMNNOTINEXTERNALMETADATA<\/li><\/ol>\n\n\n\n<p>Pour finir, la liste des codes n&rsquo;est pas tr\u00e8s digeste, ni exhaustive aujourd&rsquo;hui durant la mise \u00e0 jour de l&rsquo;article. Mais les liens sur la page officielle de Microsoft vous permettront de retrouver facilement l&rsquo;origine de l&rsquo;erreur et donc de trouver une solution pour la corriger.<\/p>\n\n\n\n<p>Enfin, pour aller plus loin, voici comment <a href=\"https:\/\/expert-only.com\/ssis\/exporter-une-table-vers-fichier-excel-avec-ssis\/\">exporter une table dans un fichier Excel avec SSIS<\/a>. Voici encore comment g\u00e9rer l&rsquo;<a href=\"https:\/\/expert-only.com\/erreur-sql-server\/erreur-de-depassement-arithmetique-lors-de-la-conversion\/\">erreur classique de conversion de type de donn\u00e9es en T-SQL.<\/a><\/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\">\nhttps:\/\/expert-only.com\/erreur-sql-server\/erreur-de-depassement-arithmetique-lors-de-la-conversion\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Voici la liste de tous les codes erreurs SSIS. Les erreurs SSIS sont souvent nombreuses et parfois, se r\u00e9v\u00e8lent difficiles \u00e0 interpr\u00e9ter, que ce soit en lan\u00e7ant les packages SSIS via l&rsquo;Agent SQL Server, depuis une ligne de commande <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\" title=\"Liste de toutes les erreurs SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10832,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[47,89,155,229],"class_list":{"0":"post-1136","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis","8":"tag-connexion","9":"tag-erreur","10":"tag-package","11":"tag-visual-studio"},"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>Liste de toutes les erreurs SSIS - Integration Services<\/title>\n<meta name=\"description\" content=\"Liste de toutes les erreurs SSIS rencontr\u00e9es pendant le d\u00e9veloppement avec Visual Studio et les liens vers la page officielle de Microsoft.\" \/>\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\/liste-des-erreurs-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Liste de toutes les erreurs SSIS\" \/>\n<meta property=\"og:description\" content=\"Liste de toutes les erreurs SSIS rencontr\u00e9es pendant le d\u00e9veloppement avec Visual Studio et les liens vers la page officielle de Microsoft.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-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-05-19T04:04:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-19T16:36:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_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=\"5 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\/liste-des-erreurs-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Liste de toutes les erreurs SSIS\",\"datePublished\":\"2022-05-19T04:04:00+00:00\",\"dateModified\":\"2022-09-19T16:36:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\"},\"wordCount\":1486,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg\",\"keywords\":[\"connexion\",\"erreur\",\"package\",\"Visual Studio\"],\"articleSection\":[\"SSIS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\",\"name\":\"Liste de toutes les erreurs SSIS - Integration Services\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg\",\"datePublished\":\"2022-05-19T04:04:00+00:00\",\"dateModified\":\"2022-09-19T16:36:33+00:00\",\"description\":\"Liste de toutes les erreurs SSIS rencontr\u00e9es pendant le d\u00e9veloppement avec Visual Studio et les liens vers la page officielle de Microsoft.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Liste de toutes les erreurs 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":"Liste de toutes les erreurs SSIS - Integration Services","description":"Liste de toutes les erreurs SSIS rencontr\u00e9es pendant le d\u00e9veloppement avec Visual Studio et les liens vers la page officielle de Microsoft.","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\/liste-des-erreurs-ssis\/","og_locale":"fr_FR","og_type":"article","og_title":"Liste de toutes les erreurs SSIS","og_description":"Liste de toutes les erreurs SSIS rencontr\u00e9es pendant le d\u00e9veloppement avec Visual Studio et les liens vers la page officielle de Microsoft.","og_url":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-05-19T04:04:00+00:00","article_modified_time":"2022-09-19T16:36:33+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Liste de toutes les erreurs SSIS","datePublished":"2022-05-19T04:04:00+00:00","dateModified":"2022-09-19T16:36:33+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/"},"wordCount":1486,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg","keywords":["connexion","erreur","package","Visual Studio"],"articleSection":["SSIS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/","url":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/","name":"Liste de toutes les erreurs SSIS - Integration Services","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg","datePublished":"2022-05-19T04:04:00+00:00","dateModified":"2022-09-19T16:36:33+00:00","description":"Liste de toutes les erreurs SSIS rencontr\u00e9es pendant le d\u00e9veloppement avec Visual Studio et les liens vers la page officielle de Microsoft.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/problem-1951987_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssis\/liste-des-erreurs-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Liste de toutes les erreurs 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\/1136","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=1136"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1136\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10832"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}