SSIS使用列位置导入Excel文档,不是名称 [英] SSIS Import Excel Document Using Column Position, Not Name
问题描述
我想知道是否可以使用SSIS通过引用列的位置来导入Excel文档?例如,导入列A,D,M,AA等我问,因为我需要从第三方加载几个Excel文档。每个文档在相应列中包含相同的数据类型,但每个文档的列名不同。
I was wondering if it was possible to import Excel documents using SSIS by referencing a column by its position? For example, import columns A,D,M,AA, etc. I ask because I need to load in several Excel documents from a third party. Each document contains the same data type in the corresponding columns, except the column names are different for each document.
谢谢!
推荐答案
是的,但您不会使用Excel驱动程序和连接管理器。相反,您将使用OLE DB驱动程序并针对该文件编写SQL查询。除了最基本的Excel文件之外,这是我从Excel导入数据的方法。
Yes but you won't be using the Excel driver and connection manager. Instead, you will use the OLE DB driver and write a SQL Query against the file. For anything but the most basic Excel files, this is my go-to approach for importing data out of Excel.
我的方法的各种形式
- Excel Source as Lookup Transformation Connection
- script task in SSIS to import excel spreadsheet
- Import a single Excel cell into SSIS
这篇关于SSIS使用列位置导入Excel文档,不是名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!