If you want to obtain certainty about the use of a mapping function, you can proceed in the same way as described under Where-used list for mappings.
Note: Mapping functions can be used in mappings as well as in job definitions 1). For the search for complex expressions, special characters 2) must be correctly escaped.
As an alternative to the content search in eBiss Dump files, you can also search directly in the database.
DECLARE @find VARCHAR(70) --SET @find = '$SerialShippingContainerCode'; SET @find = 'SG_16/RFF/DG_C506[[]@DE_1153=''VN'']/@DE_1154'; SET @find = CONCAT('%',@find,'%'); WITH Mappings AS ( SELECT (SELECT Name FROM [Node] WHERE Oid = Node_oid) AS Node, Name, CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), [MapBytes])) AS MapDefinition FROM [MapDef] ) SELECT Node,Name FROM Mappings WHERE MapDefinition LIKE @find;
DECLARE @find VARCHAR(70); SELECT @find = 'Order Outbound'; SET @find = CONCAT('%',@find,'%'); WITH Jobs AS ( SELECT (SELECT Name FROM [Node] WHERE Oid = Node_oid) AS Node, Name, CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), [JobBytes])) AS JobDefinition FROM [JobDef] ) SELECT Node,Name FROM Jobs WHERE JobDefinition LIKE @find;
Note: Mapping functions also apply to job steps that support the specification of Expressions3).