Adding a Table to Framework from a Datasource of SQL Server 2008(OLE DB)

[CalebMF]

I feel really silly asking this question, because I have done it so many times. But I haven't had the opportunity to do it in a little while, so I am rusty.
When in framework manager, how do I add a table to my already existing Connection, or data source. I am using SQL Server 2008(OLE DB) as my Data Source.
Thank you

EDIT: So I figured you would need to be within the Project Viewer, and to select a folder or view, and go to "Actions" menu and chose "Run Metadata Wizard".
So I did this. But when I get to where I can select a table, all of my tables are not there. There are none. Not even the ones I am currently using within my Data Source.
Why would this be?

[raghuram]

I am assuming that you are bringing in a new table(s) into a new Query Subject. Right-click on the Physical Layer --> Create --> Query Subject. It will then take you to a dialogue box where you select your datasource connection and follow the steps to select either entire table(s) from your source or required columns from table(s). The rest is a walk-through that is easy to understand.

[CalebMF]

.

[CalebMF]

I am assuming that you are bringing in a new table(s) into a new Query Subject. Right-click on the Physical Layer --> Create --> Query Subject. It will then take you to a dialogue box where you select your datasource connection and follow the steps to select either entire table(s) from your source or required columns from table(s). The rest is a walk-through that is easy to understand.

Thank you for your reply. Even when I try this, the tables are not appearing in my Database. I have the correct Schema and everything. Any idea?

[raghurambo]

When you say that the tables are not appearing in the database, do you mean that you don't see the tables when you connect through the dialogue box or that you are not able to bring them into FM?

Also, could you use a query tool (Squirrel or others) to query the data from the tables that you want to use in FM and see what the result set will show?

[CalebMF]

When you say that the tables are not appearing in the database, do you mean that you don't see the tables when you connect through the dialogue box or that you are not able to bring them into FM?

Also, could you use a query tool (Squirrel or others) to query the data from the tables that you want to use in FM and see what the result set will show?

I mean that I am unable to see the tables when I connect through the Dialogue box. I have checked all security with SQL Server and I am still unable to see them within the Wizard's Dialogue box.
I have never heard of or used a query tool like this. Would it help me with my current issue of not being able to see the tables?