XML Patterns - SQL Server Integration Services Design Patterns - page 279

from customer in StreamReader(pathToXmlFile,
"Customer")
select new
{
Key = customer.Attribute("Key").Value,
FirstName
= customer.Element("Name").Element("FirstName").Value,
LastName
= customer.Element("Name").Element("LastName").Value,
BirthDate = customer.Element("BirthDate").Value,
Gender = customer.Element("Gender").Value,
YearlyIncome
= customer.Element("YearlyIncome").Value,
}
))
{
try
{
CustomersBuffer.AddRow();
CustomersBuffer.Key
= Convert.ToInt32(xdata.Key);
CustomersBuffer.FirstName = xdata.FirstName;
CustomersBuffer.LastName = xdata.LastName;
CustomersBuffer.BirthDate
= Convert.ToDateTime(xdata.BirthDate);
CustomersBuffer.Gender = xdata.Gender;
CustomersBuffer.YearlyIncome
= Convert.ToDecimal(xdata.YearlyIncome);
}
catch (Exception e)
{
string errorMessage = string.Format("Error
retrieving data. Exception message: {0}",
e.Message);
bool bCancel;
ComponentMetaData.FireError(0,
ComponentMetaData.Name, errorMessage, string.Empty, 0,