Using various sources I've been able to create a working DTS package from C#, including adding two connections, a step, datapump and a transform task (without specifying columns).
However I'm unable to get it right, if I try to specify my own column mappings, adding source and destination columns to the transform task. The package is created without any errors, but the transformations are considered invalid by the DTS Designer and thus removed.
Does anybody know of examples, resources, articles, books or anything else that addresses how to create column mappings ?
Any help would be greatly appreciated.
Thomas