question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked nasreen-akter commented

FileName in Issue

Hello Team,

I have multiple files in the Blob storage and the file data has to be copied into DB Table the table name as a file

Blob storage :

141739-image.png

Azure SQL Table name :

  1. Basic data

  2. Plant Data

I am using the pipeline :

141811-image.png

And i am getting error in copy activity :

141749-image.png


Please advise how to remove the .csv extension.

Thanks in advance

azure-data-factory
image.png (13.0 KiB)
image.png (23.0 KiB)
image.png (35.3 KiB)
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.

1 Answer

nasreen-akter avatar image
0 Votes"
nasreen-akter answered nasreen-akter commented

Hi @RohitKulkarni-6062,

Would you please try:

 @substring(item().name, 0, lastindexof(item().name, '.csv'))

Thanks!


· 2
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.

Hello Nasreen,

I am facing now one more issue.The columns name from

source side :

142083-image.png

Target side :
142029-image.png



After running the pipeline I am getting errors:

142065-image.png


0 Votes 0 ·
image.png (6.5 KiB)
image.png (4.4 KiB)
image.png (14.5 KiB)

Hi @RohitKulkarni-6062,

Wondering why you have spaces in the TableName and in the columnNames. Is there any reason behind it? I would recommend not to have spaces in the TableName and in the columnNames. And try again.

Thanks!

0 Votes 0 ·