英文:
SSIS Package Fails due to ADO NET source could not create connection manager with Netsuite
问题
我已经将一些SSIS项目部署到SSIS服务器目录中,在Visual Studio环境中每个人都能够正常运行,并且可以使用ADO NET提供程序(Netsuite AnalyticsConnect数据提供程序)连接和检索NETSUITE中的数据,但当我尝试在SSIS服务器中自动运行包时,作业不运行并出现以下错误:
是否有解决此问题的方法?当连接到本地SQL Server时,我没有遇到任何其他错误或相关问题。
英文:
I've deployed some SSIS projects to SSIS Server catalog, which everyone runs perfectly in the Visual Studio environment and can connect and retrieve data from NETSUITE using the ADO NET provider (Netsuite AnalyticsConnect Data Provider) but when I try to automate the package in the SSIS Server, the job doesn't run and give the error:
Is there a way to work around this? I am not having any other errors or something related when the connection is with the local SQL Server.
答案1
得分: 0
这是一个两步骤的过程:
- 在SSIS运行时服务器上安装ADO.NET提供程序(Netsuite AnalyticsConnect数据提供程序)。
- 在SSIS运行时服务器上将驱动程序 NetSuite.SuiteAnalyticsConnect.dll 文件注册到全局程序集缓存中。
参考链接:使用ADO.NET数据提供程序进行连接
英文:
It is a two step process:
- Install ADO NET provider (Netsuite AnalyticsConnect Data Provider)
on the SSIS run-time server. - Register the driver NetSuite.SuiteAnalyticsConnect.dll file in the
Global Assembly Cache on the SSIS run-time server.
For the reference: Connecting with the ADO.NET Data Provider
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论