topic Re: Bulk Load data in MS sql server on azure in Talend Studio

Bulk Load data in MS sql server on azure

Samridhi — Sat, 16 Nov 2024 02:37:17 GMT

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/td-p/137155?lightbox-message-images-137155=13125i1410556795D30AF1

But i am getting below error

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

Re: Bulk Load data in MS sql server on azure

manodwhb — Wed, 22 Apr 2020 04:57:00 GMT

@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-code-5-access-is-denied

Re: Bulk Load data in MS sql server on azure

Samridhi — Wed, 22 Apr 2020 15:21:45 GMT

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 .