Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Tables are not appearing in Add/Remove Tables to Data Source View

Proposed Tables are not appearing in Add/Remove Tables to Data Source View

  • Thursday, May 03, 2012 9:39 AM
     
     
    Sign In to Vote
    0

    Hi All, 

    I have created a SQL Server 2008 R2 database by running some create scripts.

    I've also created two tables manually within SQL Server Management Studio.

    In BIDS, I've created a Datasource view to this database with a user that is the db_owner of the database.

    However, when attempt to create a Data Source View, and I select to Add/Remove Tables, I can only see the two I created manually.

    Any ideas why I can't see them all??

    Thanks!


    • Edited by MrMadders Thursday, May 03, 2012 9:39 AM
    •  
     

All Replies

  • Thursday, May 03, 2012 3:26 PM
     
     Proposed
    Sign In to Vote
    0

    What login is listed as the owner of the tables you created by executing the script?

    This is more than likely a permissions issue.

    Script out the tables you created manually and compare the scripts.


    Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

    • Proposed As Answer by MMilligan Thursday, May 03, 2012 3:26 PM
    •  
     
  • Thursday, May 03, 2012 11:28 PM
     
     
    Sign In to Vote
    0

    Hello Mr. Madders,

                                     The User account which you specified in the data source connection wont get used until the cube processing has been started. When you tried to alter the DSV from BIDS, it will take the user account, which you logged into the system.

    Thank you!!

    Regards,

    Pradeep.