Solution for file permission: icacls "<dir of jars and data file>" /grant "ALL APPLICATION PACKAGES:(OI)(CI)F" /T

Open command prompt as Administrator.

• This reply was modified 4 years, 4 months ago by vpader.

I did apply your suggestion. Sql server calls the java class but instead of return a value it will just handle the file on local folder. But when java is...

Haha, funny I am thinking of SSIS as we speak.

Thanks Gents! Your suggestions are making a lot of sense and I am on the same page.

I am migrating Oracle to Mssql and there is this requirement. The call route...

• This reply was modified 4 years, 4 months ago by vpader. Reason: more detail
• This reply was modified 4 years, 4 months ago by vpader.

Thanks Ken. What's the reason of avoiding? I have to explain to my team 😉