Skip to main content

Posts

Showing posts from March, 2015

XML Essentials [Episode 3] - XSLT

Different than CSS and Its styles for XML
Can be convert into anything using this(to PDF, HTML and etc)





Try yourself below:

http://www.w3schools.com/xsl/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog_apply

XML Essentials [Episode 2] - XPath

#define path into XML document

#W3C standard way to access XML data

Definitions

#"Path Expression" = series of location steps
#"Context Node" = Where path evaluation start from
#"Axis" = Relationship between context and selected nodes
#"Predicates" = Further refinement to selection process

Practice XPath Online:
> http://www.xpathtester.com/xpath
> http://www.freeformatter.com/xpath-tester.html
> http://www.w3schools.com/xpath/xpath_examples.asp

XML Essentials [Episode One]

Download the PDF > XML essentials

eXtensible Markup Language
Tag based syntax, very much like HTML but not a replacement for it
Recommendation of W3C 1998
Base for several web technologies such as XHTML, AJAX, RSS/ATOM, Web services
Used for structure and describe data
Enables communicate between different systems and services
Hosts different related technologies such as XPath, XSLT, XQuey, XPointer/ XLink

Advantages

Separates presentation layer
XML files can be read by many applications such as Java, .Net, PHP, JavaScript and etc.
Can be used with Server side and Client side

Disadvantages

Not suitable for large data files (like 1GB of data)
Not suitable for image like data
JSON may be better solution for some cases other than XML

Basics of XML

Elements Naming

Can only start with hyphen (_) or with letter
Rules of XML Syntax

Must have single root tag
Must well formed
Must have end tags
Attributes must inside quotes

XML Namespaces

Prevents from different language tags conflicting with XML tags we defining


CD…

Create a folder using SSIS script task

Following C# script can be used

public void Main()
{
// TODO: Add your code here

//reading from SSIS
string folderCheck = (string)Dts.Variables["User::DestionFolder"].Value;

if (!System.IO.Directory.Exists(folderCheck))
System.IO.Directory.CreateDirectory(folderCheck);

Dts.TaskResult = (int)ScriptResults.Success;
}