![]() Using the environment and tools mentioned above, here are the setup and steps required to load XLSX file to SQL Server Database Table via SSIS.Įnsure you have the XLSX file ready, SQL Server Instance, database and table for storing the XLSX file contents are created.ġ) Open your browser, download and install “Microsoft Access Database Engine 2010 Redistributable” (I’ll call this as “The component”) from the link given above. XLSX file into SQL Server Database table. The method works at the environment and tools I’m using, so if yours are a little bit different, your mileage may vary – regardless, if you need help, just comment out on the comment section down below. One thing to note is that, regardless whether your machine is 32-bit or 64-bit, but when you download it, choose to install the 32-bit option. Here’s the link to install Microsoft Access Database Engine 2010 Redistributable. ![]() I know, you must question me, why Microsoft Access? But this is really the correct component to use when you need to load XLSX file via SSIS. The component you need is called Microsoft Access Database Engine 2010 Redistributable. The issue is not on the configuration, but more on getting the correct component to be installed to get SSIS acknowledge the XLSX file as XLSX is not something that comes built-in when you install SSIS on even the latest Visual Studio 2019. XLS file (Excel 97 to 2003), it’s so straight forward. XLSX file to SQL Server Database table isn’t so straight-forward. Though the scenario looks simple, but as it turns out, even using the latest Visual Studio 2019, loading. This is the sample XLSX file I’m trying to load via SSIS
0 Comments
Leave a Reply. |