如何在平面文件连接管理器上重新配置列信息? [英] How to reconfigure the column information on a flat file connection manager?

问题描述

我有一个平面文件源，该源正在从平面文件读取数据.我们最近在此平面文件中添加了新列.

I have a Flat File Source that is reading data from a flat file. We have recently added a new column to this flat file.

平面文件数据插入数据库表中.为了在目标组件中容纳新字段，我使用了ALTER TABLE语句将新列添加到表中.这是我所做的唯一更改.

The flat file data is inserted into a database table. To accommodate the new field in the destination component, I used the ALTER TABLE statement to add the new column to the table. That is the only change I have done.

平面文件和目标组件之间的映射是否应该自动更改?我看不到平面文件中SSIS包内任何地方的附加列.

Should the mapping between flat file and destination component automatically change? I do not see the additional column present in the flat file anywhere within the SSIS package.

如何在SSIS包内的平面文件中配置附加列，以便平面文件源可以将数据传递到目标组件?

How do I configure the additional column in the flat file within SSIS package so that flat file source can pass the data to the destination component?

推荐答案

如果在平面文件中添加了新列，则需要更新 Flat File Connection Manager 以反映新的更改. 平面文件连接管理器将出现在软件包底部的 Connection Manager 标签下.

If you added a new column to the flat file, you need to update the Flat File Connection Manager to reflect the new changes. Flat File Connection Manager will be present under the Connection Manager tab at the bottom of the package.

让我们假设您有一个带有 StateCode 和 StateName 列的平面文件.

Let's assume that you have a flat file with columns StateCode and StateName.

配置Flat File Connection Manager时，您将看到在 Advanced 标签页下配置的这些列，如下所示.

When you configure the Flat File Connection Manager, you will see these columns configured under Advanced tab page as shown below.

如果您修改平面文件以添加其他列，请说出添加名为 CountryCode 的新列.

If you modify the flat file to add an additional column, say by adding the new column named CountryCode.

平面文件连接管理器将不包含新的列定义.您需要打开平面文件连接管理器"以添加新列，也可以删除平面文件连接管理器"并使用新的平面文件列定义创建一个新文件.

The flat file connection manager will not contain the new column definition. You need to open the Flat File Connection Manager to add the new column or you could delete the Flat File Connection Manager and create a new one with the new flat file column definition.

您需要单击新建"并选择适当的选项以插入列.您不能移动列位置.因此，请确保选择正确的选项以添加列.设置适当的属性以定义列.

You need to click New and select appropriate option to insert the column. You cannot move the column positions. So, make sure you select the right option to add the columns. Set the appropriate properties to define the column.

修改源或目标架构时，它将影响数据流任务中的源和目标组件.您可能会在组件上看到一个警告图标，如下所示，因为该组件与与其关联的连接管理器的元数据信息不同步.

When you modify source or destination schema, it will affect the source and destination components within data flow task. You might see a warning icon on the component as shown below because the component is out of sync with the metadata information of the connection manager that it is associated with.

双击显示警告的组件，然后在编辑器上单击确定"以解决映射问题.

Double-click the component showing the warning and click OK on the editor to resolve the mapping issue.

希望有帮助.

这篇关于如何在平面文件连接管理器上重新配置列信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！