question

DAITHIMCGARAI avatar image
0 Votes"
DAITHIMCGARAI asked PascalHasler-1010 answered

SSIS flexible file source Java SE is required to use ORC format

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.


sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered

Hi DAITHI,

Could you please share more error messages?

Please refer to the following links:
Flexible File Source
Flexible File Task
SQL Server Integration Services Flexible File System Task with Azure Blob Storage

Best Regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DAITHIMCGARAI avatar image
0 Votes"
DAITHIMCGARAI answered Monalv-msft commented

Hi Mona
That is the full error I get albeit the message also refers to a Web link of which I have added as the second link in my original question.
I cannot even begin the run the ssis package as soon as I click on the columns tab......the message comes up.....i will add a screen shot later.....

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DAITHI,

May I know if you have anything to update?

Best Regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·
DAITHIMCGARAI avatar image
0 Votes"
DAITHIMCGARAI answered Monalv-msft commented

Here is a screen shot of whats setup and the error message..............

23555-image.png



image.png (263.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DAITHIMCGARAI,

Please put the mouse on the red X on the Flexible File Source to see the error message.

Best Regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·
PascalHasler-1010 avatar image
0 Votes"
PascalHasler-1010 answered

I get the same error after installing Oracle SE runtime. Putting the mouse over the red x shows the message: Column mapping is missing

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PascalHasler-1010 avatar image
0 Votes"
PascalHasler-1010 answered

The solution was that after installing Oracle Java 8u192, you have to follow the instructions of the Zulu JDK installation:
1. Download and extract the installation zip package.
2. From the Command Prompt, run sysdm.cpl.
3. On the Advanced tab, select Environment Variables.
4. Under the System variables section, select New.
5. Enter JAVA_HOME for the Variable name.
6. Select Browse Directory, navigate to the extracted folder, and select the jre subfolder. Then select OK, and the Variable value is populated automatically.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.