Avatar of thomaszhwang
thomaszhwang
Flag for United States of America 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.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
thomaszhwang

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
thomaszhwang

ASKER
Thanks.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck