I know that proc metadata can extract almost all from DI studio(tables, Jobs, transformations names, columns etc.) but I didn't found that it can extract also some source code of transformation from some concrete ETL.
So I have general question:
Can I somehow(by proc metadata etc.) extract source code of some transformation in some concrete ETL?
For example, I have DI studio job(ETL) which has few transformations , and one of them - "user written code"( or simple "SQL join" it's not important) and I need get source code of this transform without connecting to DI studio manually, for example by running some standard proc metadata with appropriate XMLmap and another options in Enterprise Guide.