使用ssis从数据库向excel导入数据时出现以下错误: ssis error code dts_e_oledb_excel_not_supported: the excel connection manager is not supported in the 64-bit version of ssis, as no ole db provider is available. 这是由于机器是64位的,没有64
使用ssis从数据库向excel导入数据时出现以下错误:
ssis error code dts_e_oledb_excel_not_supported: the excel connection manager is not supported in the 64-bit version of ssis, as no ole db provider is available.
这是由于机器是64位的,没有64位的ole db provider。
解决方法:在project菜单中选择properties,在左侧选择degugging,将run64bitruntime属性置为false。然后再execute package,成功。
参考链接:http://wenku.it168.com/d_000602554.shtml