on 04-27-2011 3:04 PM
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
Hello, I am trying to achieve something similar, any chance you could share your script (or maybe part of it)?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is resolved using SQL Script Task
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.