Cloning existing sources

When adding a script, ETL Services provides a convenience cloning function. This is very useful when you want to make standard transformations based on a single data source and substitute the transformed values for the originals.

When adding a script, if cloning an existing source, a new source is created with the same columns as the original and a script is pre-populated that simply copies the original. You can then un-target the original data source and make any desired modifications to the cloned one to use the transformed data source. Common cases include manipulations of date or string columns to conform to standard reporting.