Script Component as Source – SSIS

Posted by on Jan 29, 2011 in Scripting, SSIS | No Comments

There are many situations which you can use power of scripting in SSIS data flow. Today I encounter a situation here , there is source flat file here with header and trailer records which have different structure from data rows. Data rows delimited by vertical line ( | ) , but header and trailer not. ...

Read More

Retrieve Part of XML File

Posted by on Jan 24, 2011 in Scripting | No Comments

Today I faced a question on changing style of an xml file and fetch desired result as another xml file,  The XML file has lots of un-necessary tags which should be removed , I tried to do this with C#.NET code. This is the input xml: <?xml version="1.0" encoding="utf-16"?><DataTable>  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">    <xs:element ...

Read More

Great New Year 2011 Gift – Microsoft MVP Award

Posted by on Jan 1, 2011 in Awards | No Comments

Today at the first day of 2011, I received a great gift from Microsoft. Microsoft Most Valuable Professional Award ( MVP ). I believe that this award is related to my contribution of technical communities such as MSDN and Exprets-Exchange , and also my posts in this blog in SSIS field. So I want to ...

Read More