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 about Retrieve Part of XML File[…]
There are lots of time which you want to get latest created file in a directory and do something with it, for example do a data transfer or do a file system task like delete or move. As you may know the Foreach Loop Container in SSIS can loops through files of a directory, But Read more about Find Last Created File in Special Directory – SSIS[…]
Few days ago, I encounter a request which asks for delete files on remote ftp folder which are older than 10 days with SSIS tasks. Suppose date of each file is embeded in the file name like this: zzz_2010-10-25 03-00-22.txt As you may know , using Foreach loop with configuring enumerator as file enumerator will Read more about Loop through FTP Files On Remote Folder and Delete OLD Files – SSIS – .NET Code[…]
Suppose you have a flat file which is not delimited or fixed width or Ragged right. the structure of data is not well formed for Flat File Connection manager to read, This is an example of data file: date : 04/14/2010customer name : John doeaddress : 2014 apple st. Chicago, IT 30000sale order Read more about How to use Script Component as Asynchronous Transformation[…]