Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Querying Excel Datasource

Status
Not open for further replies.

Bonediggler1

Technical User
Jul 2, 2008
156
US
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!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top