cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to call script logic from package

Former Member
0 Likes
228

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.

View Entire Topic
chemicala_srimallikarjuna
Active Contributor
0 Likes

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