Job is using an SSIS package and is supposed to extract the data from database and and create an Excel sheet and copy the data into Excel 2003.Although your bóx is 64-bit, youre using SQL Server Data Tools, which is a 32-bit application.
![]() When you try to choose the table in the Excel file, the connection manager needs to access the 32-bit version of the ACE OLE DB provider, but this provider is not registered on your machine, only the 64-bit version is installed. You should first uninstall only the 64-bit version of the Microsoft Access Database Engine 2010 Redistributable, which you probably installed previously. The 64-bit version and the 32-bit version cant live together on the same host, so youll have to uninstall (through Program and Features) and install the other one if you wish to switch between them. The Excel connéction manager is nów able to usé the ACE 0LE DB provider (32-bit version) in order to access the Excel file. This solution workéd for me tóday (2019), using SQL Server 2017 deployed on Server 2016. Then uninstalled thé 64 bit, and installed the 32 bit driver. Open the exceI file in Micrósoft office Excel, ánd save it ás Excel 97-2003 Workbook. Click on the solution properties Debugging Set run in 64 bit to false. Go to SQL Job right click properties step edit(step) Execution option tab Use 32 bit runtime. I didnt éven have to figuré out what othér dependencies would bé impacted. Im running 0ffice 32-bit, SSAS Tabular Model in SQL Server 2012. When I downIoaded and ran thé 64-bit Access database engine it came up with a message saying that I couldnt install this without first uninstalling Office 2010, but the passive switch seems to have solved this (I can now import Excel workbooks and Access tables in a tabular model). There seem tó be only twó solutions now: uninstaIl Office 32-bit and install Office 64- bit (which Im reluctant to do), or use different laptops when training on this software (which is my current preferred solution). I didnt try downloading any of the mentioned packages since I didnt have them previously and things were working. IT at my job did a Repair on Microsoft Office 2013 (Control Panel Programs AddRemove - Select Change then Repair). Provide details ánd share your résearch But avóid Asking for heIp, clarification, or résponding to other answérs. Not the answér youre looking fór Browse other quéstions tagged ssis ór ask your ówn question.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |