Page 1 of 1

copying stage variable names

Posted: Thu Aug 20, 2009 1:28 am
by mukejee
Hi All,
Can anybody help me how to copy all stage varible names ?
I am having more than 50 stage variables and i want to copy only the stage variable names.

thanks in advance
MUS

Posted: Thu Aug 20, 2009 2:28 am
by laknar
DSGetStageInfo(hJob,stagename,DSJ.VARLIST)

Posted: Thu Aug 20, 2009 3:49 am
by ArndW
Do you want to copy them from one transform stage to another? I don't know of a way to do this in the designer, unfortunately. It might be possible to do via cut-and-paste from a .dsx export file.

Posted: Thu Aug 20, 2009 3:56 am
by Sainath.Srinivasan
Copy-and-paste the transformer and change the derivations.

Posted: Thu Aug 20, 2009 3:58 am
by thompsonp
Why not use copy and paste, then clear all the derivations. It's only a 3 step process.

Posted: Thu Aug 20, 2009 7:26 am
by chulett
I think you should be able to select all / copy and then 'Paste Column' rather than 'Paste Derivation' to get only the columns.