March 3, 2017 at 8:34 am
I am self teaching myself SSIS with having absolutely no prior knowledge.
I want to import data from an Excel Document (already set up) to SQL Mgt Studio (have now created a table for the said excel data).
I have created new SSIS connections - my SQL database and my Excel Connection Manager which leads to the above Excel document.
In the data flow task window, I have dragged the Excel source and clicked edit. When I go to update the "Name of the Excel Sheet", a pop up box says "could not retrieve the table information for the excel connection manager. Failed to connect using the excel connection manager.
In the Solutions Explorer, the excel connection manager is called Excel Connection Manager.conmgr.
Why is it not connecting to my Excel Document?
thanks in advance
March 3, 2017 at 8:47 am
thanks for replying.
the path goes to my local network drive. Wondering whether to put the file on my c drive to see if that makes a difference.
No idea about JET/ACE drivers - highly likely no. Does you need them for it to work?
March 3, 2017 at 8:59 am
Normally the ACE drivers are installed when you install Excel, do you have that installed on the machine you are using? If you have an older version of Excel installed, and you're trying to access an xlsx file you'll have a problem here (JET is the older version for xls files). You can download the drivers here.
And provided that the account you are using Visual Studio on has access to the Network path, then access won't be a problem.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 3, 2017 at 9:07 am
For the purposes of getting your feet wet with SSIS, I would recommend that you try importing a CSV file rather than getting sidetracked with the intricacies of Excel drivers.
March 3, 2017 at 9:15 am
I will try that. thanks.
March 3, 2017 at 9:20 am
It seems to have worked so far.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply