The Value Mapping component is an SSIS data flow transformation component that can be used to manage translation of input values.

With the Value Mapping component, developers have four options to handle non-matched values: Replace As, Set as Empty, Leave it as is, or, Raise an Error.

The Value Mapping component is part of the SSIS Productivity Pack.

SSIS Value Mapping Component

Value Mapping Component: data integration made easy

Our solution is easy to use, offering code-less integration between the Value Mapping component and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

Value Mapping component is available within the Conversion components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Value Mapping component with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

Other Conversion Components

Our Conversion components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to Value Mapping, the Conversion components include: