SQLTeam.com | Weblogs | Forums

Unable to connect to the excel or msaccess file in SSIS

tsql
sql2008
sql2012

#1

Hi all

Just started MSBI ,very new

I am trying to connect to excel source..But its shows an error any idea ? or suggestion ?


#2

Did you configure an 'Excel Connection Manager'? It looks as if it's prompting you to set one up.


#3

sorry, configuring excel ?

i installed odbc drivers .i will try to check in google configuring excel manager

same error ,please suggest how to resolve

please help


#4

A similar usecase is covered in this sql server solution page. If you are still having a trouble, you should try the following driver . You will be able to find the relevant documentation at the bottom of this page.


#5

please post a screen shot of your excel spreadsheet ?