Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Copy Column Transformation Editor

Updated: 17 July 2006

Use the Copy Column Transformation Editor dialog box to select columns to copy and to assign names for the new output columns.

To learn more about the Copy Column transformation, see Copy Column Transformation.

ms189379.note(en-US,SQL.90).gifNote:
When you are simply copying all of your source data to a destination, it may not be necessary to use the Copy Column transformation. In some scenarios, you can connect a source directly to a destination, when no data transformation is required. In these circumstances it is often preferable to use the SQL Server Import and Export Wizard to create your package for you. Later you can enhance and reconfigure the package as needed. For more information, see Creating Packages Using the SQL Server Import and Export Wizard.

Available Input Columns

Select columns to copy by using the check boxes. Your selections add input columns to the table below.

Input Column

Select columns to copy from the list of available input columns. Your selections are reflected in the check box selections in the Available Input Columns table.

Output Alias

Type an alias for each new output column. The default is Copy of, followed by the name of the input column; however, you can choose any unique, descriptive name.

Release History

17 July 2006

Changed content:
  • Provided guidance about when to use the Import and Export Wizard instead of the Copy Column transformation.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.