SSIS - Modify Script

[Former Member]

Hi all,

we are working with SAP BPC MS 7.5 SP4 on Windows Server 2008 64 bit and MSSQL 2008 64 bit.

Our installation is on three servers.

We developped a SSIS package and we link it to BPC by EData-->Organize Package List menu.

We also tried to edit 'ModifyScript' variable by 'DataManager Dynamic Script', but BPC doesn't save our script.

There isn't any error but if we re-open the package, the script is blank.

We use an user (the same developped SSIS package) with all task profile selected (system admin and primary admin).

We have full acces on ApplicationSet folder.

As workaround, we modified Modify script variable into SSIS project.

Have you any idea about our issue?

Thanks in advance.

Best regards,

massimo

[Former Member]

Hi Massimo,

In SSIS, everything is case sensitive. So the variables you edit in SSIS is also case-sensitive. SSIS will consider ModifyScript and MODIFYSCRIPT as different objects. So always use MODIFYSCRIPT as the variable in SSIS to modify the Data Manager dynamic script, as said in prvious post.

Karthik AJ

[Former Member]

Hi Massimo

I had the exact same issue, but on version 7.0, it turned out that the variable type "String" will only allow 4000 characters, our dynamic script had more than 4000 characters and it wouldn't save the package. also, the MODIFYSCRIPT had to be in uppercase

Hope this Helps

Kind Regards

Daniel