Share via

  • Article

DTS_W_EXTERNALMETADATACOLUMNSOUTOFSYNC

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

-2147192632

Event Source

dtsmsg.rll

Component

Integration Services 

Symbolic Name

DTS_W_EXTERNALMETADATACOLUMNSOUTOFSYNC

Message Text

The external columns are out of synchronization with the data source columns.

Explanation

The column metadata in the data source does not match the column metadata in the source or destination component that is connected to the data source.

The hexadecimal value for this error number is 0x800470C8.

Possible Causes

The column metadata in the data source was modified. However, this modification was not made to the column metadata in the source or destination component that is connected to the data source.

User Action

In Business Intelligence Development Studio, in the SSIS Designer, right-click the source or destination component, and then click Edit. When a message appears that asks whether you want to replace the column metadata in the component with the column metadata in the data source, click Yes. Integration Services will automatically update the column metadata in the component to match the column metadata in the connected data source.