This information was copied from Link.
Once you’ve added a setting to the Excel settings spreadsheet, it’s readily accessible to your BizTalk application at runtime.
To read a setting value at runtime from maps, orchestrations, pipeline components or .NET code:
1. Complete the steps outlined in Configuration Settings in SSO – Part 1.
2. Copy SSOSettingsFileReader.dll from the Deployment Framework for BizTalk install folder to a reference location in your BizTalk solution
The settings API is housed in a .NET 2.x assembly named SSOSettingsFileReader.dll. Before you can use it in your application, locate the DLL in FrameworkDeployTools and copy it to a folder within your BizTalk solution folder hierarchy. It’s a good idea to check the DLL into your source control system and reference it in that location vs. the Deployment Framework’s install folder.
3. Add a reference to SSOSettingsFileReader.dll to your project
In any BizTalk or .NET project, add a reference to the copy of SSOSettingsFileReader.dll in your solution folder structure.
4. Call the settings API
The SSOSettingsFileReader class has static methods for retrieving an individual value as well as for retrieving a Hashtable for the entire set of name-value pairs. This class caches the settings and periodically refreshes them from the SSO server.
The affiliateApplication is the value of the element in your deployment project file (.btdfproj). The valueName is the name of a setting (row) in the spreadsheet.
public class SSOSettingsFileReader
public static void ClearCache(string affiliateApplication);
public static Hashtable Read(string affiliateApplication);
public static int ReadInt32(string affiliateApplication, string valueName);
public static string ReadString(string affiliateApplication, string valueName);
public static void Update(string affiliateApplication, Hashtable ht);