Thanks Gary for the Link.
I have implemented my dimension table change with the way they showed up in
http://sqlblog.com/blogs/michael_coles/archive/2010/11/20/high-performance-dimensional-data-loads-with-ssis-presentation.aspx.
I was able to achieve the goal but i am...