<div>
Dung Dinh, isn't it what I posted earlier?
</div>


Dung Dinh, isn't it what I posted earlier?

<div>
Hi YZlat,<br />
<br />
Because I had the same problem when I developed SSIS packages to load Excel file. And I also approached the above solutions.<br />
<br />
I just shared my experience with the problem.
</div>


Hi YZlat,

Because I had the same problem when I developed SSIS packages to load Excel file. And I also approached the above solutions.

I just shared my experience with the problem.

<div>
Thanks all for your kindly help and sorry for closing this late..
</div>


Thanks all for your kindly help and sorry for closing this late..

<div>
<div class="content wysiwyg-content">
SSIS version is 2012, excel version is 2013. <br />
I create a excel data source in SSIS, choose excel version as &quot;excel 2007&quot;, and then point it to my excel file.<br />
However I cannot load any data from excel file to SSIS, the error message is as pasted. BTW, I have already installed &quot;AccessDatabaseEngine_x64&quot;<wbr /> on the server. May I ask if there is a solution to this? Thank you very much! <a href="https://filedb.experts-exchange.com/incoming/2015/08_w34/930038/ssis-error.png" target="_blank" title="ssis-error.png (36 KB)"><img alt="ssis-error.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/08_w34/800_930038/ssis-error.png" /></a>
</div>
</div>


ssis-error.png

SSIS version is 2012, excel version is 2013. 
I create a excel data source in SSIS, choose excel version as "excel 2007", and then point it to my excel file.
However I cannot load any data from excel file to SSIS, the error message is as pasted. BTW, I have already installed "AccessDatabaseEngine_x64" on the server. May I ask if there is a solution to this? Thank you very much! 

Excel data source doesn't work in SSIS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.