Using SSIS is it possible to populate two output columns from one input column?

rwheeler23 used Ask the Experts™
I have a csv flat file full of customer names and addresses. One of the goals of this import process is to clean up addresses. In SQL I have added an additional field called MOD_ADDRESS. This is an exact copy of the ADDRESS field. It will be this field I will be correcting via other scripts. Is possible to populate both the ADDRESS and MOD_ADDRESS fields during the initial import task from the one input column? Since I can map the input column called ADDRESS to only one SQL column, how can I also populate the MOD_ADDRESS column at the same time?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Yes, you can use Derived Column Transformation in SSIS and then use Derived Column to add ADDRESS as a new column named MOD_ADDRESS. an example of using Derived Column Transformation below..



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial