XML Data Load Using SSIS Script task C#.Net
XmlDataDocument xmldoc = new XmlDataDocument (); XmlNodeList xmlnode,xmlnode1; int i = 0,j=0; string str = null ; string FilePath = Dts.Variables[ "User::File_Name" ].Value.ToString(); int nodecount = 0; FileStream fs = new FileStream (@FilePath, FileMode .Open, FileAccess .Read); xmldoc.Load(fs); xmlnode = xmldoc.GetElementsByTagName( "TagName" ); xmlnode1 = xmldoc.GetElementsByTagName( "AnotherTagName" ); nodecount = xmlnode.Count; for (i = 0; i <= xmlnode.Count - 1; i++) { for (j = 8; j <= xmlnode[i].ChildNodes.Count - 2; j++) { str = xmlnode[i].ChildNodes.Item(0).InnerText.Trim() + "|" + xmlnode[i].ChildNodes.Item(1).InnerText.Trim() + "|" + xmlnode[i].ChildNodes.Item(2).InnerText.Trim() + "|" + xmlnode[i].ChildNodes.Item(3).InnerText.Trim() + "|"