Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Updating a table in data source view in BIDS

Author  Topic 

TPie9
Yak Posting Veteran

67 Posts

Posted - 2010-12-29 : 13:40:15
I updated a Fact table in management studio. However when I process my project in BIDS the Fact table isn't updating with the new column and therefore I can't add the new dimesion. How do I get the new column in the Fact table in the data source view?

Thanks

TPie9
Yak Posting Veteran

67 Posts

Posted - 2010-12-29 : 15:29:29
Thanks goodness I'm new and don't feel so dumb, okay a little maybe. All I had to do was open the data source view and on the toolbar click data source view and then choose refresh and my fact table was updated with the new column from management studio.
Go to Top of Page
   

- Advertisement -