Hello
Any help on this issue would be appreciated!
I have a simple piece of SQL which runs without error in Management Studio, but when trying to run the same SQL in SSIS using an Execute SQL Task I get the following error...
ERROR
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
SQL
INSERT INTO OPENROWSET(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=d:\temp\Book1.xls;;HDR=YES',
'SELECT * FROM [TAB1$]')
SELECT
*
FROM
table