I am creating a SSIS package where I'll import an Excel table. I am having problem setting up the connection manager with Excel 2007 data source. I have SP2 and tried the following sources:
Microsoft Office 12.0 Access Database Engine OLE DB provider.
Microsoft OLE DB provider for Analysis Services.
Error: I defined the file and filepath but when I press TEST CONNECTION, I get a message that no such host is known.
If anybody knows exactly which provider works with Excel 2007 source pls. let me know.
I googled on this but did not get a working solution from any site.