https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46621#M12442 Hi all,<BR /> 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.<BR /> So I have general question:<BR /> Can I somehow(by proc metadata etc.) extract source code of some transformation in some concrete ETL?<BR /> 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.<BR /> <BR /> So is it possible get such information?<BR /> <BR /> Thanks! Fri, 08 Apr 2011 10:55:49 GMT Yura2301 2011-04-08T10:55:49Z https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46621#M12442 Hi all,<BR /> 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.<BR /> So I have general question:<BR /> Can I somehow(by proc metadata etc.) extract source code of some transformation in some concrete ETL?<BR /> 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.<BR /> <BR /> So is it possible get such information?<BR /> <BR /> Thanks! Fri, 08 Apr 2011 10:55:49 GMT https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46621#M12442 Yura2301 2011-04-08T10:55:49Z https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46622#M12443 This forum is oriented toward questions about SAS procs. You'll probably have better luck getting an answer if you ask your question in the <A href="http://support.sas.com/forums/forum.jspa?forumID=59" target="_blank">SAS Enterprise Data Management &amp; Integration</A> forum.<BR /> <BR /> Good luck! Fri, 08 Apr 2011 14:54:34 GMT https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46622#M12443 Tim_SAS 2011-04-08T14:54:34Z https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46623#M12444 Thanks Tim! Sat, 09 Apr 2011 07:35:16 GMT https://communities.sas.com/t5/SAS-Procedures/Get-transformation-source-code-from-DI-studio-ETLs/m-p/46623#M12444 Yura2301 2011-04-09T07:35:16Z