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 fro

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; }