SQL SSIS Package ending at 33%?-CodePudding

So i'm setting up a script to get data from an sql database and output it into an excel file. When creating the ssis package in smss, and i select the option to run immedietly, it works. As soon as i try to execute it from my bat file, It says the following error. I had gotten it to work a few times, but now no matter what i do i cant run this anymore without getting the error. sqlexpress 2019 with smss 2019, office 2016 standard 32bit & both ACE providers 16.0 32x and 64x installed. Any idea's?

Progress: 2022-05-19 10:54:28.24
   Source: Data Flow Task 1
   Validating: 0% complete
End Progress
Progress: 2022-05-19 10:54:28.24
   Source: Data Flow Task 1
   Validating: 33% complete
End Progress

And then it just stops here... Why does it get to 33% and then stop? The query is correct, When i run the query in smss, it outputs what I need. But here randomly it stopped working.....

CodePudding user response：

sqlexpress does not support execution of existing SSIS packages. You must have a licensed developer/standard/enterprise instance installed on the machine to run a stored SSIS Package. SQL Express only allows you to create and run a package immediately.

Reference on Express not support https://docs.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver15#install-integration-services

CodePudding user response：

So I figured out the answer, I uninstalled office 2016 from the computer, and it worked.

Thanks!