Hi, Each time I use a Data conversion tranformation, SSIS adds new column. Is there any way to ignore the older copy of the column going forwards in the remaining transformaiton? Let me try to explain the quesiton with below example. I do want the converted column( [Copy Of BusinessEntityId]) and want to ignore the original column [BusinessEntityID].

This is an oft requested feature. There's no way to hide a column from the UI(which I think is what you're asking for) however I think that would be a useful feature. I have asked for it on Connect (I'd paste the link but the paste function in my stupid phone isn't working properly - go search for "ssis connect hide columns pipeline") but they've said they're not going to implement it.     ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Until this UI feature gets added simply remove the mapping from your destination.http://btsbee.wordpress.com/

You could do the cast in the source query: http://microsoft-ssis.blogspot.com/2011/01/cast-and-convert-to-avoid-data.html SELECT CAST(someColumn AS nvarchar(50)) AS someColumn FROM someTable or an other (dirty/inefficient) trick is to use a union transformation to remove/rename some columns. See this post of Todd: http://toddmcdermid.blogspot.nl/2010/07/conversion-between-unicode-and-non.html#!/2010/07/conversion-between-unicode-and-non.html And there is also an open source component by Todd: http://toddmcdermid.blogspot.nl/2010/08/convert-several-columns-in-ssis-with.html#!/2010/08/convert-several-columns-in-ssis-with.html Also see this request from Jamie: https://connect.microsoft.com/SQLServer/feedback/details/252462/ssis-hide-columns-in-the-pipeline Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter