Add switches in your machine.config file. and use debug view for custom logging
<system.diagnostics> <switches> <add name="BizTalkESBToolkit2.2" value="4"/> </switches> </system.diagnostics>
Add switches in your machine.config file. and use debug view for custom logging
<system.diagnostics> <switches> <add name="BizTalkESBToolkit2.2" value="4"/> </switches> </system.diagnostics>
Simple Expression can validate your email address inside orchestration
boolIsmail = System.Text.RegularExpressions.Regex.IsMatch(strmail, @"\A(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)\Z",System.Text.RegularExpressions.RegexOptions.IgnoreCase );
select sndport.nvcName as 'HostInstaceSendPort',
hostInstace.Name as 'HostInstanceName' ,hostInstace.LastUsedLogon as 'loginUser' ,
hostInstace.DateModified as 'DateofCreation'from
dbo.bts_SendPort sndport inner join
dbo.bts_sendport_transport SndPorttransport
on ((sndport.nID = SndPorttransport.nSendPortID) and (SndPorttransport.nSendHandlerID is not null))
inner join
dbo.adm_SendHandler SndHandler
on SndPorttransport.nSendHandlerID = SndHandler.Id
inner join
dbo.adm_Host hostInstace
on SndHandler.HostId = hostInstace.Id
bindingExtensions>
<add name="sqlBinding" type="Microsoft.Adapters.Sql.SqlAdapterBindingCollectionElement, Microsoft.Adapters.Sql, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<add name="sapBinding" type="Microsoft.Adapters.SAP.SAPAdapterBindingSection, Microsoft.Adapters.SAP, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<add name="oracleDBBinding" type="Microsoft.Adapters.OracleDB.OracleDBAdapterBindingSection, Microsoft.Adapters.OracleDB, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<add name="siebelBinding" type="Microsoft.Adapters.Siebel.SiebelAdapterBindingSection, Microsoft.Adapters.Siebel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
<add name="oracleEBSBinding" type="Microsoft.Adapters.OracleEBS.OracleEBSBindingCollectionElement, Microsoft.Adapters.OracleEBS, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</bindingExtensions>
<client>
<endpoint binding="sqlBinding" contract="IMetadataExchange" name="mssql" />
<endpoint binding="sapBinding" contract="IMetadataExchange" name="sap" />
<endpoint binding="oracleDBBinding" contract="IMetadataExchange" name="oracledb" />
<endpoint binding="siebelBinding" contract="IMetadataExchange" name="siebel" />
<endpoint binding="oracleEBSBinding" contract="IMetadataExchange" name="oracleebs" />
<metadata>
<policyImporters>
</policyImporters>
<wsdlImporters>
</wsdlImporters>
</metadata>
</client>