SSIS Tutorial Part 77.1-Split Single Column Into Multiple Columns in SSIS Package

In this video we will learn how to split single column such as Full address into multiple columns such as StreetAddress,City,State and Zip. There are multiple ways to split single column into multiple columns in SSIS Package. In this video we will be using Derived Column Transformation to split single column into multiple columns in SSIS Package. In this demo you will also learn How to use Substring Function in Derived Column Transformation in SSIS Package How to use FindString Function in Derived Column to Find the index value for character in SSIS Package How to use LEN Function in Derived Column Transformation in SSIS Package You will learn how to write expressions in Derived Column Transformation in SSIS Package Also How to Convert the data type of column in derived column Transformation. blog post link with expressions http://sqlage.blogspot.com/2015/04/how-to-split-full-address-into-multiple.html