源文件连接(平面文件)-不读取列元数据 [英] Source File Connection (Flat File) - Not reading column metadata
问题描述
当我创建SSIS包时，它需要引用一个文件来拾取文件元数据.例如，列标题将为ColumnA，ColumnB.
When I create the SSIS package it requires a file to be referenced to pick up the files metadata. For example the column headers will be ColumnA, ColumnB.
我一直认为文件中必须存在这些列名称才能加载它.最近，由于某种原因，业务将文件中的列名之一更改为其他名称，因此文件包含ColumnA，NotColumnB.当SSIS程序包运行时，它将忽略此操作并加载文件.我以为它会失败.我的假设是正确的，并且发生了一些奇怪的事情，还是我的假设不正确，如果是这样，请告诉我原因.
I have always assumed that these column names need to be present in the file for it to be loaded. Recently business, for whatever reason, changed one of the column names in the file to something else so the file contains ColumnA, NotColumnB. When the SSIS package runs it ignores this and loads the file. I assumed that it would fail. Is my assumption correct and there is something weird going on or is my assumption incorrect, if so please let me know why.
我已经更改了一些其他软件包的列名，这些软件包从文件中加载数据，而且它们也不关心列名是什么
I have changed the column names in a few other packages that load data from a file and they also dont care what the column names are
推荐答案
单击平面文件源，然后按 F4 以显示属性"选项卡.有一个名为ValidateExternalMetadata的属性，将其更改为True.
Click on the flat file source, and press F4 to show the properties tab. There are a property called ValidateExternalMetadata change it to True.
有关更多信息，请检查以下答案:
For more information check the following answer:
平面文件连接管理器似乎没有验证引擎，定义的元数据在配置时用于配置数据文件和数据库之间的映射.
It looks like that flat file connection manager has no validation engine and the metadata defined is used at configuration time to configure the mappings between the data file and the database.
- Why Does't SSIS Flat File Data Check If Columns Names or Order Have Changed? What is best way to check?
- Flat file destination columns data types validation
这篇关于源文件连接(平面文件)-不读取列元数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
