Deployment Storage Options for SSIS Package

Posted by on May 20, 2011 in SSIS | No Comments

There are 3 different storage types for SSIS packages when you want to deploy a SSIS package from BIDS with Save a copy of package as ….  These Different types are: SQL Server File System SSIS Package Store each of these types described as below; SSIS Package Locations when you want to deploy package from ...

Read More

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

Dynamic Row Delimiter and Column Delimiter in SSIS

Posted by on Dec 10, 2010 in SSIS | No Comments

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

Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS

Posted by on Nov 11, 2010 in ETL, SQL Server, SSIS | No Comments

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