The Transformations collection is a group of Transformation2 objects that contain information about the transformation, and about source and destination columns.
Transformations specifies the collection of transformations that transfer data from the data source to the data destination.
HRESULT GetTransformations(IDTSTransformations **pRetVal);