![]() ![]() ![]() (I am no longer working in this area.)Īfter researching everywhere finally i have found out temporary solution. The answer by GavB841 below looks promising, if anyone tries it and it works please let me know. XLSX and the connection is set to Excel 2007. I should add that it is an excel 2007 file. The directory is shared to Authenticated users and the file is not in use.Īny ideas how to debug this error? I understand there can be issues running this in 64 bit mode, but does that apply to development? I can't find this error logged anywhere and i don't know why it is failing. "Could not retrieve the table information for the connection manager.įailed to connect to the source using the connection manager. When I add an Excel Source to the DataFlow and specify the excel connection, when I go to the Name Of the Excel Sheet Drop down I just see "No tables or views can be loaded" and get the following error. I have added an excel connection and pointed it at the Excel file on a local disk (the same file I have already successfully imported using the import wizard). The problem happens when trying to design the package. ![]() I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server. I have a server that is capable of creating and running an Excel Import task using the Import Wizard. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |