for my client I would like to take a predefined flat file from SAP containing chart of account details (account id, description and parent) and load and process them automatically using dtsx packages in BPC 7.0 MS.
Also, I want the package to able to be able to change details when it finds an already existing account id (e.g. if the description changes) and only for the properties contained in the flat file (i.e. keep the property values the same in BPC for those properties which are not in the extract for existing account records), or to add new accounts for those that don't exist. I don't want the existing dimension completely replaced, as the SAP file won't contain info for fields like ACCTYPE, or TYPEELIM for example.
I find the help in Data Manager extremely confusing and am not sure which bits are current or have been superceeded.
I am an application consultant with limited knowledge of DTS/ SSIS and I wonder if someone can give me a step by step detail of what I must do to achieve this. I am sure that many people would like to do something similar.