Skip to Content
Former Member
Dec 08, 2009 at 08:49 AM

Storing sensetive information in SSIS Packages


Hi, all!

We use SAP BPC 7.0 sp 06 on SQL Server 2008. We designed packages on test enviroment for load data from SAP BI system to BPC using SAP BI Connector 1.0 and it works well. But when I copy this package from test enviroment to prod server sensetive information disappeare (password to SAP BI system) - I save package with ProtectionLevel - EncryptSensetiveWithUserKey (all standart BPC packages designed with this option). I can only change ProtectionLevel to EncryptSensetiveWithUserPassword. But I cannot run it from BPC with this option. And after copiing to prod server I must loggin in BIDS on prod server change ProtectionLevel to EncryptSensetiveWithUserKey and resave it to BPC folder. It's not suitable way for me.

Does anybody try use Package Configuration such as XML file SQL Sever store? I tried use SQL Server store (save password to SAP BI system in SQL table) but it fails after one load succes load and login to SAP BI system blocked (3 unsucsses entering of password) even at test enviroment.

Thank all for help.