Forum Discussion
Anonymous
8 years agoNot applicable
Multiple tables for a single dataset
Hello, I'm trying to create a data set from one of my data sources. I would like to import multiple tables from a database of SQL Server, but I am not able to do so. Do you know if it's possible?...
- 8 years ago
Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.
Jon-Heide
8 years agoMicrosoft Employee
Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.