Help Updating A Table

,
1

I have a TestName Table with 2 columns; ServiceName and State which accept integer for their State(0=inactive, 1=active)

I have a document with two strings, ServiceName and State(Pick List of Active and Inactive)

I also have a service which reference this document, invoking an upDate adapter to update my TestName Table

I want to upDate a TestName table’s ServiceName with either an Active or Inactive State from my service, but is will store 1 in database for Active and 0 for Inactive

How do I configure a service to upDate this table, receiving a string(Active or Inactive) from my service but store an integer 1 for Active or 0 for Inactive into my table

Thanks

2

Hosea:

Map the values in the pipeline without any convertion.

regards.