COPY Data Issue

Question

COPY Data Issue

Rohit Kulkarni 731

Hello Team,

The snowflake is in AWS and DB is in Azure sql DB.

So i am transferring the data from SNowflakeTable-->Blob and from Blob-->Azure sql DB Table.

1st copy command

Source Table Name =VW_SERVICELOCATION_MERGE

In Blob copied as =SERVICELOCATION.csv with this command :@markus.bohland@hotmail.de (replace(replace(item().Table_name,'VW_',''),'_MERGE',''),'.csv')

Blob storage :

2nd copy command :

Source : I am not able to use the same command @markus.bohland@hotmail.de (replace(replace(item().Table_name,'VW_',''),'_MERGE',''),'.csv').
I need to consider only servicelocation.csv.

Please advise me which function i need to consider.

ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-12-15T14:31:55.283+00:00

Hi @Rohit Kulkarni ,

Following to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

1 answer

Your answer

ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-12-15T14:31:55.283+00:00

Hi @Rohit Kulkarni ,

Following to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer 1

ShaikMaheer-MSFT 38,556 Microsoft Employee Moderator

Hi @Rohit Kulkarni ,

Thank you for posting query in Microsoft Q&A Platform.

I believe you are using your both copy activities inside ForEach activity.

You can consider storing your .csv file name in to variable first and then using that variable inside Copy activities.

Kindly check below image for high level idea of implementation, what I am suggesting.

Hope this will help. Please let us know if any further concerns.

-------------

Please consider hitting Accept Answer button. Accepted answers helps community as well.

ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-12-13T12:48:39.02+00:00

Hi @Rohit Kulkarni ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Rohit Kulkarni 731 Reputation points

2021-12-15T16:28:13.85+00:00

Its resolved in a different way.Thanks for the prompt response
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-12-21T16:45:53.517+00:00

Hi @Rohit Kulkarni - Thank you for response. Feel free to share your work around as answer and mark it as accepted answer. Thank you.

Share via

COPY Data Issue

1 answer

Your answer