Bulk load failed with error using copy

Question

Bulk load failed with error using copy

hemanth vootla 1

Hi Team,

Objective is to bulk load the table using csv which is available in azure storage. Trying to load the data from tesfile.csv to table airtravel which is available in the test sql pool.

Document followed

https://learn.microsoft.com/en-us/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest

COPY INTO dbo.airtravel FROM 'https://madhuritestdatalake.blob.core.windows.net/madhuraitestdatalakefile/2_ExportSourceDataWithBCP/testfolder/tesfile.csv' WITH ( FILE_TYPE = 'CSV', CREDENTIAL = (IDENTITY= 'Storage Account Key', SECRET='mykey'), FIELDTERMINATOR=',', ROWTERMINATOR=';' );

Received error

error Msg 110813, Level 16, State 1, Line 1 The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. Completion time: 2021-10-16T23:24:35.8581042-04:00

Regards
Hemanth

Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-10-19T04:41:18.043+00:00

Hi @hemanth vootla ,

Thanks for using Microsoft Q&A !!
It looks like issue with your secret. Can you please check if you have removed "==" sign from the end of your secret.
A valid secret would look like the below-

Thanks
Saurabh
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-10-26T04:18:05.62+00:00

Hi @hemanth vootla ,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-11-03T17:43:43.533+00:00

Hi @hemanth vootla ,

We haven't heard back from you. Just wanted to check if you are you still facing the issue?

Thanks
Saurabh

Your answer

Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-10-19T04:41:18.043+00:00

Hi @hemanth vootla ,

Thanks for using Microsoft Q&A !!
It looks like issue with your secret. Can you please check if you have removed "==" sign from the end of your secret.
A valid secret would look like the below-

Thanks
Saurabh
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-10-26T04:18:05.62+00:00

Hi @hemanth vootla ,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh
Saurabh Sharma 23,846 Reputation points Microsoft Employee Moderator

2021-11-03T17:43:43.533+00:00

Hi @hemanth vootla ,

We haven't heard back from you. Just wanted to check if you are you still facing the issue?

Thanks
Saurabh

Share via

Bulk load failed with error using copy

Your answer