替换SSIS脚本任务连接字符串provider = microsoft.ace.oledb.12.0 [英] Alternate of SSIS script task connecting string provider=microsoft.ace.oledb.12.0

问题描述

我有一个SSIS脚本任务，我已经编写了一些逻辑来将sql查询结果写入excel文件。我正在使用连接字符串为Provider = Microsoft.ACE.OLEDB.12.0 ，但它又要求安装Microsoft Office Access数据库引擎2007，由于某些许可证问题，不允许在我的服务器中下载和安装。如果建议任何备用连接提供商，那么它非常感谢和帮助。



我尝试过：



我尝试使用连接提供程序Microsoft.ACE.OLEDB.12.0，它在安装Microsoft Office访问数据库引擎2007时工作正常但是由于许可证问题我们无法做到在服务器中。

I am having a SSIS script task from which I have written some logic to write sql query results to excel file.I am using the connecting string as Provider=Microsoft.ACE.OLEDB.12.0,but again it is asking to install Microsoft office access database engine 2007 which is not allowed to download and install in my server due to some licence issue.If any alternate connection provider will be suggested then its really appreciated and helpful.

What I have tried:

I have tried using the connection provider Microsoft.ACE.OLEDB.12.0,its working fine when the Microsoft office access database engine 2007 is installed,but due to licence issue we can't do it in server.

推荐答案

写入CSV或XML文件，而不是写入Excel文件。这两个都可以加载到Excel中。

Instead of writing to an excel file, write to a CSV or XML file. Both of those can be loaded into Excel.

这篇关于替换SSIS脚本任务连接字符串provider = microsoft.ace.oledb.12.0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！