You configure the Copy Column transformation by specifying the input columns to copy. You can create multiple copies of a column, or create copies of multiple columns in one operation. This transformation has one input and one output. It does not support an error output. You can set properties through the SSIS Designer or programmatically. For more information about the properties that you can set in the Copy Column Transformation Editor dialog box, see . The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in theAdvanced Editor dialog box or programmatically, click one of the following topics: Data Conversion Transformation SQL Server 2012 2 out of 6 rated this helpful - The Data Conversion transformation converts the data in an input column to a different data type and then copies it to a new output column. For example, a package can extract data from multiple sources, and then use this transformation to convert columns to the data type required by the destination data store. You can apply multiple conversions to a single input column. Using this transformation, a package can perform the following types of data conversions: Change the data type. For more information, see . Note If you are converting data to a date or a datetime data type, the date in the output column is in the preference may specify a different format. Set the column length of string data and the precision and on numeric data. For more information, see . Specify a code page. For more information, see . Note When copying between columns with a string data type, the two columns must use the same code If the length of an output column of string data is shorter than the length of its corresponding column, the output data is truncated. For more information, see . This transformation has one input, one output, and one error output.
You configure the Copy Column transformation by specifying the input columns to copy. You can create multiple copies of a column, or create copies of multiple columns in one operation. This transformation has one input and one output. It does not support an error output. You can set properties through the SSIS Designer or programmatically. For more information about the properties that you can set in the Copy Column Transformation Editor dialog box, see . The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in theAdvanced Editor dialog box or programmatically, click one of the following topics: Data Conversion Transformation SQL Server 2012 2 out of 6 rated this helpful - The Data Conversion transformation converts the data in an input column to a different data type and then copies it to a new output column. For example, a package can extract data from multiple sources, and then use this transformation to convert columns to the data type required by the destination data store. You can apply multiple conversions to a single input column. Using this transformation, a package can perform the following types of data conversions: Change the data type. For more information, see . Note If you are converting data to a date or a datetime data type, the date in the output column is in the preference may specify a different format. Set the column length of string data and the precision and on numeric data. For more information, see . Specify a code page. For more information, see . Note When copying between columns with a string data type, the two columns must use the same code If the length of an output column of string data is shorter than the length of its corresponding column, the output data is truncated. For more information, see . This transformation has one input, one output, and one error output.