can't able to move blob to sql server db through adf

Prabhakar Karunakaran - Consultants 21

i am trying to move more than 3 csv files dynamically from blob to db but while moving some of the column dates got deleting kindly please help me

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-08-05T22:50:55.433+00:00

Hello @Prabhakar Karunakaran - Consultants ,
Thanks for the question and using MS Q&A platform.

Can you please clarify the below

1) were you able to see the data in the data preview in the sink?
2) once you have loaded the data, you mentioned seeing dates getting deleted. I see you are using filter and derived column activities in the transformation. Could it be something to do with these transformations?

Could you please share the sample source data in a text attachment(mask any personal data)? Also, please let us know your filter and derived column operations.

Thanks,
Bhargava
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-08-10T00:24:25.983+00:00

Hello @Prabhakar Karunakaran - Consultants ,
I am just checking in to see if you have any updates here.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-08-13T03:25:29.067+00:00

Hello @Prabhakar Karunakaran - Consultants ,
I am just checking in to see if you have any updates here.

Your answer