Bonediggler1
Technical User
Hi
I am wondering if, when using a SQL Command to get data out of an Excel datasource, 1) What type of SQL syntax is used (same as Access?) and 2) If subqueries are allowed and/or 3) What are the limitations in querying Excel from SSIS?
Thank you!!
I am wondering if, when using a SQL Command to get data out of an Excel datasource, 1) What type of SQL syntax is used (same as Access?) and 2) If subqueries are allowed and/or 3) What are the limitations in querying Excel from SSIS?
Thank you!!