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屋！
