Thursday, February 21, 2013 11:12 AM
I am trying to query the excel using the OPEN Rowset
I have configured the connection manager correctly (test connection is working).
When I am trying to write query in the source during the preview it is giving me syntax error as shown in the screenshot, I have tried all the ways from google but not working can anybody suggest anything in this :
"Syntax error in FROM Clause"
SELECT * FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0','Excel 12.0 XML;Data Source=C:\Users\sumit.kumar.dua\Desktop\Sumit\Common.xlsx;HDR=YES', 'SELECT * FROM [Sheet1$]')
Thanks in advance
Thursday, February 21, 2013 11:14 AMPlease re-submit your screen shot as th eimage is missing...
MCSA: (SQL 2012, SQL 2008, Windows Server 2008) MCITP: (SQL BI & SQL 2008) MCT: 2000 - 2013 www.lite-solutions.co.uk
Thursday, February 21, 2013 12:44 PM
There is some problem I am not able to post image :
This is the error message I am getting when clicking on preview
Exception from HRResult: OxC0202009
Error at Data Flow Task[OLE DB Source]: SSIS Error code DTS_E_OLEDBError. An OLE DB error has occured. Error code:0x80040E14.An OLE DB record is available. Source: "Microsoft Office Access Database Engine" Hresult: 0x80040E14 Description: "Syntax error in FROM clause".
The query which I am using I have posted above
Friday, February 22, 2013 6:34 AMModerator
Friday, February 22, 2013 7:49 AM
Yes it is having, Are there are any enviornment prerequisites required ?
Monday, February 25, 2013 7:07 PMModerator
Tuesday, February 26, 2013 6:14 AM
Yes I tried to preview the data by selecting the table its working fine the problem is with the query or something is wrong.