I upgraded a set of ssis packages from 2005 to 2008r2. the corresponding database has ben upgraded from sql2005 to sql2014. The packages run fine from BIDS. But when i execute them from new sql server agent job ( i have checked the use-32 bit runtime check box)., the package fails with error message as
我从2005年到2008年升级了一套ssis软件包。相应的数据库已经从sql2005升级到sql2014。 BIDS的套餐运行良好。但是当我从新的sql server代理作业执行它们时(我已经检查了use-32位运行时复选框)。,包失败并显示错误消息
Executed as user: ADMIN\SvcSQL13DVMDDEW03. Microsoft (R) SQL Server Execute Package Utility Version 10.50.6000.34 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:57:06 Error: 2017-07-27 11:57:08.96 Code: 0xC0209302 Source: CBSBankRec50244961Transform Connection manager "TempRBGLINT" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider SQLNCLI10.1 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2017-07-27 11:57:08.97 Code: 0x00000008 Source: Check Database Connection Description: The script returned a failure result. End Error Error: 2017-07-27 11:57:24.55 Code: 0xC0202009 Source: CBSBankRec50244961Transform Connection manager "RBGLINT" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server [2]. ". End Error Error: 2017-07-27 11:57:24.57 Code: 0xC00291EC Source: Log Package 'Started' Execute SQL Task Description: Failed to acquire connection "RBGLINT". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Error: 2017-07-27 11:57:40.21 Code: 0xC0202009 Source: CBSBankRec50244961Transform Connection manager "RBGLINT" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server [2]. ". End Error Error: 2017-07-27 11:57:40.22 Code: 0xC00291EC Source: Log Package 'Failure' Execute SQL Task Description: Failed to acquire connection "RBGLINT". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:57:06 Finished: 11:57:40 Elapsed: 34.102 seconds. The package execution failed. The step failed.
以用户身份执行:ADMIN \ SvcSQL13DVMDDEW03。 Microsoft(R)SQL Server执行包实用程序版本10.50.6000.34(适用于32位版权所有(C)Microsoft Corporation 2010.保留所有权利。开始时间:11:57:06错误:2017-07-27 11:57:08.96代码:0xC0209302来源:CBSBankRec50244961Transform连接管理器“TempRBGLINT”描述:SSIS错误代码DTS_E_OLEDB_NOPROVIDER_ERROR。请求的OLE DB提供程序SQLNCLI10.1未注册。错误代码:0x00000000。 OLE DB记录可用。来源:“Microsoft OLE DB服务组件”Hresult:0x80040154描述:“类未注册”。结束错误错误:2017-07-27 11:57:08.97代码:0x00000008源:检查数据库连接描述:脚本返回失败结果。结束错误错误:2017-07-27 11:57:24.55代码:0xC0202009源:CBSBankRec50244961Transform连接管理器“RBGLINT”描述:SSIS错误代码DTS_E_OLEDBERROR。发生OLE DB错误。错误代码:0x80004005。 OLE DB记录可用。来源:“Microsoft SQL Server Native Client 10.0”Hresult:0x80004005说明:“登录超时已过期”。 OLE DB记录可用。来源:“Microsoft SQL Server Native Client 10.0”Hresult:0x80004005说明:“建立与SQL Server的连接时发生了与网络相关或特定于实例的错误。未找到或无法访问服务器。请检查实例名称是否正确,如果SQL Server配置为允许远程连接。有关详细信息,请参阅SQL Server联机丛书。“ OLE DB记录可用。来源:“Microsoft SQL Server Native Client 10.0”Hresult:0x80004005描述:“命名管道提供程序:无法打开与SQL Server的连接[2]。”。结束错误错误:2017-07-27 11:57:24.57代码:0xC00291EC源:日志包'已启动'执行SQL任务描述:无法获取连接“RBGLINT”。可能未正确配置连接,或者您可能没有此连接上的权限。结束错误错误:2017-07-27 11:57:40.21代码:0xC0202009源:CBSBankRec50244961Transform连接管理器“RBGLINT”描述:SSIS错误代码DTS_E_OLEDBERROR。发生OLE DB错误。错误代码:0x80004005。 OLE DB记录可用。来源:“Microsoft SQL Server Native Client 10.0”Hresult:0x80004005说明:“登录超时已过期”。 OLE DB记录可用。来源:“Microsoft SQL Server Native Client 10.0”Hresult:0x80004005说明:“建立与SQL Server的连接时发生了与网络相关或特定于实例的错误。未找到或无法访问服务器。请检查实例名称是否正确,如果SQL Server配置为允许远程连接。有关详细信息,请参阅SQL Server联机丛书。“ OLE DB记录可用。来源:“Microsoft SQL Server Native Client 10.0”Hresult:0x80004005描述:“命名管道提供程序:无法打开与SQL Server的连接[2]。”。结束错误错误:2017-07-27 11:57:40.22代码:0xC00291EC源:日志包'失败'执行SQL任务描述:无法获取连接“RBGLINT”。可能未正确配置连接,或者您可能没有此连接上的权限。结束错误DTExec:包执行返回DTSER_FAILURE(1)。开始时间:11:57:06完成时间:11:57:40经过:34.102秒。包执行失败。步骤失败了。
The provider used in the config files for the packages is SQLNCLI10.1 . in the ssis package there is a ole db connection manager - RBGLINT. Just for information - this was automatically upgraded from sql native client \oledb provider to sql native client \ ole db provider 10.0. in the connection manager. I do not see this causing the issue. But just for information.
包的配置文件中使用的提供程序是SQLNCLI10.1。在ssis包中有一个ole db连接管理器 - RBGLINT。仅供参考 - 这是自动从sql native client \ oledb provider升级到sql native client \ ole db provider 10.0。在连接管理器中。我不认为这导致了这个问题。但仅供参考。
Any inputs?
1 个解决方案
#1
0
From the error message you provided the main error is:
从您提供的错误消息中,主要错误是:
The requested OLE DB provider SQLNCLI10.1 is not registered
请求的OLE DB提供程序SQLNCLI10.1未注册
From the link below you there is 2 methods for solving this issue:
从下面的链接可以找到解决此问题的两种方法:
The requested OLE DB provider SQLNCLI10.1 is not registered
请求的OLE DB提供程序SQLNCLI10.1未注册
-
you need to do is to open the connection manager/connection string and edit it to use Native Client 11.0 which is what comes as default with SSIS 2014
您需要做的是打开连接管理器/连接字符串并对其进行编辑以使用Native Client 11.0,这是SSIS 2014的默认设置
-
Another alternative is to install the Native Client 10.0 from SSIS 2008 installable:
另一种方法是从SSIS 2008安装Native Client 10.0:
#1
0
From the error message you provided the main error is:
从您提供的错误消息中,主要错误是:
The requested OLE DB provider SQLNCLI10.1 is not registered
请求的OLE DB提供程序SQLNCLI10.1未注册
From the link below you there is 2 methods for solving this issue:
从下面的链接可以找到解决此问题的两种方法:
The requested OLE DB provider SQLNCLI10.1 is not registered
请求的OLE DB提供程序SQLNCLI10.1未注册
-
you need to do is to open the connection manager/connection string and edit it to use Native Client 11.0 which is what comes as default with SSIS 2014
您需要做的是打开连接管理器/连接字符串并对其进行编辑以使用Native Client 11.0,这是SSIS 2014的默认设置
-
Another alternative is to install the Native Client 10.0 from SSIS 2008 installable:
另一种方法是从SSIS 2008安装Native Client 10.0: