Hi
I am trying to read orc files so that I can take the data from them and load into a sql database.
I am using the SSIS package that was an addition to SSDT and its an azure addon (SSIS AZURE Feature pack https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15 ) called flexible file source.
But every time I use the format as ORC files and give it a folder and file I get the message 'java se is required to use orc/parquet format'....
So I follow the instructions here and install oracle java se (https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15#dependency-on-java)
So I then run the ssdt I made with a data flow to connect flexible file source and I keep getting the same error............I have tried a few versions of java se and none seem to work...........I keep getting the error..........I have tried in 32 and 64 bit versions.
All help appreciated.
