When we develop a custom component to load data to SQL Server , do you need 
a
BeginTransaction(), a commit and a rollback or is it not required since it i
s
a com+ component. I am new to biztalk and com+.


public class AICPipeSQL: ServicedComponent, IBTSAppIntegration
{
public AICPipeSQL()
{
}

string IBTSAppIntegration.ProcessMessage(string strDocument)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(strDocument);
SqlDataAdapter oDa = new SqlDataAdapter();
DataSet oDs = new DataSet();
//SQLTransaction         ?????????


//Logic to extract data from the XML and load tp database

return strDocument;
}

private DataSet RetrieveStagingData(string groupValue)
{

}
}

[ Post a follow-up to this message ]