Tag Archive : XML

Unable to instantiate XML DOM document : SSIS 2005

0
Digg me

SSIS 2005 Business Intelligence
Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered.
 Other variations are  Failed to save package file “.dtsx” with error 0x8002801D “Library not registered.”

The reason you see this error is because MSXML got corrupted.

The fix is

1. Close Studio / Business Intelligence

2. Download Latest MSXML 4.0 (sp3)  as of today.

3. Install it. Done

2a. Some cases you may need to install MSXML 6.0.

Disable .xml file generation when building Asp.Net application

0
Digg me

Visual Studio 2005 – Compile Options

.XML files are used to create Documentation.

If you need to disable them, then

Project Properties > Compile and Uncheck Generate XML Documentation file option.

ASP.Net – XML & Table – 1

0
Digg me

Standard Namespace includes[%@ Import Namespace = "System.Collections.Hashtable" %]
[%@ Import namespace="System.Text.regularexpressions" %]
[%@ Import Namespace="System.Type" %]
[%@ Import Namespace="System.Data" %]
[%@ Import Namespace="System.Drawing" %]
[%@ Import namespace="System.IO" %]
[%@ Import namespace="System.Text" %]
[%@ Import namespace="System.Math" %]
[%@ Import namespace="System.XML" %]—————————————————————-Clearing Server Cache  in 1 sec. If specific for variable mention variable name
instead of None.[%@ outputcache duration="1" varybyparam="None" %]
——————————————————————————————–Parsing XML documentDim xdoc as new XMLDataDocument()Dim allitems as XmlNodeList
Dim childitems as XMLNodelistDim attrColl as XmlAttributeCollection
Dim childatts as XmlAttributeCollection’Opening the Reference XML file
xdoc.DataSet.ReadXML(server.mappath(“.”) & “/XMLData/StaticRates.xml”)’Getting Threshhold Value
ThreshholdNode = xdoc.selectsinglenode(“//cendataProducts/conformingThreshold”)
Threshholdvalue = Convert.ToSingle(ThreshholdNode.innerxml)– if needed to parse the html inside CData
HomeEquityFooter =
xdoc1.selectsinglenode(“//cendataProducts/homeequityfooter”).innertextallitems = xdoc.selectNodes(“//cendataProducts/section”)For i = 0 to allitems.count -1
 attrColl = allitems(i).Attributes attrColl(“title”).Value childitems = allitems(i).ChildNodes
 For x = 0 to childitems.count-1
  childatts = childitems(x).Attributes
 Next
Next i——————————————————-Number Formatting, variable needs to be SingleString.Format(“{0:c0}”,SingleVariable) — Currency conversion
String.Format(“{0:f2}”,SingleVariable) — Decimal 2 places——————————————————————–
Server side Table instead of controls.[asp:table id="tblData" runat="server" Width="645px" /]tblData.Rows.Add(BuildPointDescRow(“col1″, “col2″))Private Function BuildPointDescRow(ByVal Heading1 As String, ByVal Heading2 As
String) As TableRow
 Dim oRow As New TableRow()
 oRow.Cells.Add(New TableCell())
 With oRow.Cells(0)
  .Font.Name = “Verdana”
  .Font.Size = New FontUnit(8)
  .Width = New Unit(500)
 End With oRow.Cells.Add(New TableCell())
 With oRow.Cells(1)
  .Font.Name = “Verdana”
  .Font.Size = New FontUnit(8)
  .Width = New Unit(15)
 End With
 BuildPointDescRow = oRow
End Function