cancel
Showing results for 
Search instead for 
Did you mean: 

Automate BPC masterdata load from flat file

0 Kudos

Hello,

Developing a SSIS package to automate the following steps,

1. read flat file from server and load itnto a temparory table

2. read temporary table and write to dimension tables (mbr and dim)

I achieved step1 successfuly using Flat File Connection, OLEDB Connection tasks and the temp table is loaded with data from flat file.

for step2 i added MakeDim control flow and i have two issues below,

Issue1. It is overwritting the mbrtable by removing all existing records instead how to just append to it

Issue2. After the mbrtable is updated the task FAILS for some reason, i am not sure why.

is it because the dimenion i am updating is not part of any applications in the appset ?

any best practise doc available on this pls share across.

Regards

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello, I am trying to achieve something similar, any chance you could share your script (or maybe part of it)?

0 Kudos

This is resolved using SQL Script Task