cancel
Showing results for 
Search instead for 
Did you mean: 

Run SSIS package in background process

Former Member
0 Kudos

Hi, all!

We use BPC 7.0 MS version SP03. We faced whith problem in automatization of SSIS package execution, that runs script logic. We can't insert our logic in default.lgf. Our users want that package is run by clicking button on report and they don't want to select parameters in package interface. Parameters have to inserts automaticaly from CV. Idealy users want that interface of Package doesnt apear and all calculation do automaticaly.

How can we do such operation?

Thank you for answers.

Best regards,

Iaroslav

Accepted Solutions (0)

Answers (2)

Answers (2)

sorin_radulescu
Employee
Employee
0 Kudos

Sorry but I really don't understand.

You would like to perform the calculation for CVW which is a script logic.

I don't understand why you can not use default logic for this.

Actually you are asking to perform the calculation exactly for CVW when you press send button.

It seems to be perfect choice default logic.

Any way if you have a very complex calculation taking a long time then it is true that it is not a good practice to have that into default logic but again it is not a good practice to have multiple users running that calculation in paralel.

So you have actually to implement a control account.

Which means every time when you press the button for calculation actually you are sending value 1 for that CTRACC.

You will create a batch program which will check all the entities, for a specific category and time having that CTRACC = 1.

For all these entities you will run the calculation in one shoot. it will be faster and you will have only one process running in the background.

At the end of logic you will put the CTRLACC = 0 which means the calculation was done.

If the logic has an error then CTRLACC =2.

So in this way you are able to control everything and the DM package is running in background.

Regards

Sorin Radulescu

i045436
Advisor
Advisor
0 Kudos

Hello,

This need a custom design in VB on the report level and asp page on the webserver side. The idea is to build a custom asp page on the server that run the DTS using the dtsrun command. On the client side you can design a VB macro which is getting the CV parameters and call the asp page with parameters.

Hope this help you,

Mihaela