Series of articles and tutorials on SSIS can be tracked in the below link, which has sample on each and every transformation and the data flow tasks. http://f5debug.net/tutorial/ssis.php Please post your comments and any real time scenario which needs to be covered