How to execute Script logic file

[Former Member]

Hi,

I want to execute a "stand alone" scipt logic file only once. Simply spoken, the script should write some members from application A to application B (I would set the scope for the members that are concerned in the script itself) once. Is there a way to do this? If possible, I would like to get around customizing the DTS packages or use them in a simple way (e.g. can I simply say sth like package==mylogicfile.lgf), without learning all the DTS syntax...

[Former Member · Accepted solution]

Hi,

There isn't much syntax to learn to get it to run really. Just copy the ICElim package and replace the ICElim.lgx with your own lgf/lgx file.

And if you are only going to do this once, why don't you just write a piece of SQL to do the copy across?

Regards,

Andires

[Former Member · Accepted solution]

(side remark: I copied the whole ICElim...dtsx to a new MyPackage.dtsx, bc. copying from within the data manager will still uses the same ICElim...dtsx as the package...)

Thanks! If I want to execute for members of all Times and Categories, do I have to set the scope manually or will it take all members by default?

[Former Member · Accepted solution]

Hi,

It should have all your members in scope if you don't specify them in your script or in the dimension member select that the user will see before running the package.

Regards,

Andries

[Former Member]

copying and customizing ICElim worked

[Former Member]

Hi

Can u please share me wat is the solution u done for copying the data from1 app to another application.

i need to copy from A app to B app where i need to write my logic. wheather in A or B.

thanks

Edited by: Prem Kumar on Sep 9, 2009 9:43 PM