How to call script logic from package

[Former Member]

Have written some script logic in the respective application. But it is not visible at the time of running the package.

How to make sure the script logic can be called from package execution.

[chemicala_srimallikarjuna · Accepted solution]

Hi,

Procedure :

1.create a new SSIS package that points to your new logic file. Simply open Default.dtsx and save it with a new name.

2.In the logic file name property put in MyLogic.LGF. The lgx file is created when you validate the lgf. If you leave off the extension in the property e.g. MyLogic, then it will default to the compiled file. However, it is a best practice to reference the lgf explicitly so that the logic file recompiles at run time to be sure it's in sync with any structure changes that may have been made since it was last compiled.

3.Once you create the new SSIS package then you would go into data manager and choose organize packages and add the new package into the DM list.

Regards

CSM Reddy

[Former Member]

Hi Manil,

For example your CT logic as like below

//=============================================

// Currency translation logic

//=============================================

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','%CATEGORY_SET%','','GLOBAL','%SCOPETABLE%','%LOGTABLE%')

1. Create your script logic and validate and save.

2. Create business rules.

3. Create your data manger package which inclue with stored procedure as "SPRUNCONVERSION".

At the time of running datamanger package, datamanger triggers script logic to run stored procedure.

Regards

Naveen.KV

[former_member5075]

Hi Manilyer,

If it is a normal script which you wrote in the script logic segment of respective application and want to include it while running package. Two ways.

1. If you want this logic for all packages, you can then just include the script directly in Default.lgx file instead of creating a new file.

2. If you want different logics for different packages, then you can create different .lgx file for that respective application and in Excel interface where you create packages. Modify the package which you want to run and in View and script editor screen give the .lgx file name under Dynamic package script (folder)->Task file ->LogicFile property.

regards,

Sreedhar