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 about Script Component as Source – SSIS[…]
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[…]
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 about Great New Year 2011 Gift – Microsoft MVP Award[…]
If you defined an output column in script component of type DT_NTEXT and you want to fill it with a string data, note that you can not use usual way like: Row.MyNTEXTColumn="something" this will not work for NTEXT, but you can use this way: Row.MyNTEXTColumn.AddBlobData(System.Text.Encoding.UTF8.GetBytes("something"))
There are times that you want to make Row Delimiter and Column Delimiter dynamic in Flat File source, and you want to change these values dynamically with package variables. usually you can use EXPRESSION properties for making things dynamic in SSIS, such as ConnectionString and bind it to a package variable. As you may know Read more about Dynamic Row Delimiter and Column Delimiter in SSIS[…]
In previous post I presented a way for UPSERT in MySQL with SSIS 2008, in this post I present another solution which is compatible with SSIS 2005 for UPSERT in MySQL Table.As previous post shows, the main problem is: There are lots of links which described how to UPSERT( Update / Insert ) between two Read more about Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS 2005[…]
There are lots of links which described how to UPSERT( Update / Insert ) between two SQL Server tables. which mostly used Lookup Transform with OLEDB Command, like this:http://www.insideit.fr/post/2010/06/17/Lookup-simple-sur-SSIS But when you work with MySQL there is a limitation, you can not use OLEDB Connections, you can use ODBC or ADO.NET Connectors from .NET to Read more about Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS[…]
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[…]
This is a common mistake which SSIS developer’s thinks that they need Foreach Loop for transfer multiple files from ftp to local or from local to ftp.I had a post about using masks in FTP task for transfer multiple files, but it seems that I should clarify this more than before. Note that you don’t Read more about Transfer Multiple Files from or to FTP remote path to local path – SSIS[…]