asked on

In SSIS, is there a way to update the fact table without writing customized code?

I know, theoretically, I'm not supposed to update the fact table, but in my special case, I need to do so.

Is there any standard tool I can use to update the fact table? Thanks.

ASKER CERTIFIED SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thomaszhwang

ASKER

That's what I meant. The fact data pulled from the transaction system changes from time to time. I need to keep them updated in the data warehouse as well. For example, in the Transaction table, there is a Transaction_Comment field need to be pulled into the data warehouse for reporting, but its value is changing all the time.

Let me know if this answer what you asked. Thanks.

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thomaszhwang

ASKER

I was just wondering if there is any easier way to do the update part. Since using a Script component and write the code and SQL command to do the update is very tedious if there are lot of fields in the fact table needs to be updated.

SOLUTION

Ryan McCauley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

thomaszhwang

ASKER

Thanks.