![]() Just wondering if anyone else has successfully configured their server to be able to use OPENROWSET to XLSX files and also have SSIS on the same server, Or does someone know if this configuration is not possible?Įdit: I should add that the failing packages are run from an SQL Agent job. Since doing that, our existing packages are failing. ![]() The server already has the 32-bit version installed, so we installed it with the /passive switch. In order to be able to import XLSX files directly from T-SQL (via OPENROWSET), we installed on the dev server the Microsoft Access Database Engine Redistributable 64-bit. Our dev server has SQL Server 2008 R2 64-bit with SSIS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |