copying stage variable names

mukejee · Post by **mukejee** » Thu Aug 20, 2009 1:28 am

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

laknar · Post by **laknar** » Thu Aug 20, 2009 2:28 am

DSGetStageInfo(hJob,stagename,DSJ.VARLIST)

ArndW · Post by **ArndW** » Thu Aug 20, 2009 3:49 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 20, 2009 3:56 am

Copy-and-paste the transformer and change the derivations.

thompsonp · Post by **thompsonp** » Thu Aug 20, 2009 3:58 am

Why not use copy and paste, then clear all the derivations. It's only a 3 step process.

chulett · Post by **chulett** » Thu Aug 20, 2009 7:26 am

I think you should be able to select all / copy and then 'Paste Column' rather than 'Paste Derivation' to get only the columns.