loading only the needed tables from SQL Server

[AishwariyaV]

Hi all,

Is there any way to make restrictions, so that I will be able to load ONLY the tables that is required, from the data source.

[cnweke]

I don't really understand your question. 

When you connect to your data source you manually select which tables you need. 

[AishwariyaV]

The problem is, the dataset which I have has more than 10000 tables.

When Previewing, it is showing only 10000 tables.

[cnweke]

With tables you mean records right? And that's normal, preview only shows a subset of your data. Once you load it, it should contain however many records you have.

[AishwariyaV]

Yeah, records. When I import dataset from SQL Server, the navigator shows only 10000 records. But i have more than that. 

[cnweke]

Once you physically import them, it'll be more than that figure. Try it. 

Preview does literally what it says... give you a preview.

In SQL terms it just does:

Select top 100000 (*) from YourTable

Importing it does:

Select * from YourTable

EDIT: If you're LITERALLY talking about having 100000 tables (and not records) then just import with a SQL statement instead of using the navigator.