Bulk Load data in MS sql server on azure

[Samridhi]

HI All,

I want to load bulk data in mssql server on azure but my talend vm and sql server are on different VM's . Also sql server is PAAS .

I have referred below link and have done all the steps mentioned in this link

https://community.talend.com/t5/Design-and-Development/How-to-guide-Bulk-Insert-to-Azure-SQL-Server/... 

But i am getting below error 

tdbbulkexec " could not be opened. Operating system error code 5(Access is denied.) 

[manodwhb]

@Samridhi , check the below links may help.

https://www.sqlservercentral.com/forums/topic/operating-system-error-code-5access-is-denied

https://sqlbak.com/blog/cannot-bulk-load-because-the-file-could-not-be-opened-operating-system-error...

[Samridhi]

Hi ,
My job design looks like
File -> azure blob. Connection -> azure put->tmssqlbulkexec

File got successfully loaded on azure storage . But bulk component is
failing with below reason

Operation system - error code 5 access denied

I have tried with tdbrow as well using bulk command but it also gives same
error .