Hi, I need help...I need to migrate data from excel to 2 sql table.each row in excel refers to one set. Excel Data: @Name@Country@Industry@EmpId Siddhi India Banking 112 Ram Us ' '. 113 Hetal ' ' Account Expected output Data table in sql DataId ProductId. TestId 101 5 4 102. 5. 4 103. 5. 4 DataParameter table DataParamerterId DataId Parameter ParameterValue 1 101 Name Siddhi 2 101 Country India 3 101 Industry Banking 4 101 EmpId 112 5 102 Name Ram 6 102 Country US 7 102 EmpId 113 8 103 Name Hetal 9 103 Industry Account

Hello Ma'am.... I'll be really grateful if u cud extend this topic further and display Pandas and ML libraries etc in action on Batch Pool... Was just doing an interview task and found it difficult. In the end I went ahead with Databricks Python activity.

Hi I am getting keywords not supporting in server

Is it possible to copy data from one cosmos collection to another collection? (Its like migration)

Congrats! Thank you for sharing!!!

I want that key to be intact on the new generated file. How to do that?

Why you removed the space fron sink there is no space

Simple matching will update and not match then insert on keycolum

Thanks for the info, Spent money and taught us , Appreciate.. You will be get back.

Hello! Your video help me to resolve a technical test. Thank you very much! 🙏

you didn't explain how to create the batch pool and use in ADF please make a video end to end

Is there any function for column empty

Thank you

Can these packages then be run from SQL Agent? When I try, I get error Failed to decrypt protected XML node "AccountKey" with error 0x8009000B "Key not valid for use in specified state."

Aap UK aa jao achchhi salary wali job mil jaayegi. Yaha cloud skill wale ki bahot demand hai. If need any info please let me know.

very well explained in details. Thanks for uploading this video.

Please share what's app group if have any its better

Hi Medam Need help here Every day folder is creating my pipeline like folder name ABC This folder again it will create tomorrow exection same folder but before executing pipeline I need to rename the same folder with date,after that my pipeline will create same ABC folder how we can implement in adf

How can we do this unroll by using dynamic expression?

How do we set dynamic folders and filename for sink side using data flow activity ? Can you please guide ?

Can you pls post more about data flows pls,with multiple transformations

Hi i want to send few adf scenarios asked in the interview how can i send you question.

hi having source file json have 1.5gb data while load getting error..can u provide me the best approach

thanks for sharing, but this is insane in ADF😂

thank you so much for creating such informative videos

in iteration you have warning it throughs error when I run my pipeline with the same logic. for example iteration variable @range(1, add(div(int(variables('rowcount')), 1000), 1)) The function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type

I am getting this error while testing connection- Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-3QLQ8J1\SQLEXPRESS', Database: 'sales1', User: 'ph'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) The certificate chain was issued by an authority that is not trusted

I am starting the ADF series today and I hope I can complete it. Please wish me luck

how to do for the Synapse.? , does synapse run with same post URL?

Any networking considerations we need to make for storage account and dbx cluster

How to delete dataset in azure synaps analyst

How to merge multiple xml file to one xml file using ADF?

4 years later, your video is still useful, thank you very much :)

Need help to upgrade SSIS 2008 to 2019? After upgrading the BCP inout package it’s running extra 2mins. In all the jobs Can you please help

Can u please make a video fir how to load data bricks dataframe( huge size) to SQL .if its already there can u share the link please.thanks

Thanks..ur efforts are helping us all..god bless you and your family

Can i add 1 activity for case 1 and case 2? Can we club 2 case statements ?

A very beautiful experience which I have never come across...very awesome ma'am

Thanks for the video, my ADF pipeline with copy activity is timing out after 30 mins what should i do?

As usual very nice 🎉

Good Video

Ma'am how to do transfermation of folders to folders. in source i have many folders under that i have files so those folders need to transfer target dynamiclly

hello mam, Mostly we write data into cosmos, it will has lot of nested column structure so how will you address his.

This video is super useful for beginners. Thanks a lot❤

Startdate and enddate as yyyyMM format give some example pls

I thank you so much for the video. It saved my day. I am really thankful 🙏

What if our sink destination is an SQL table?? How can we create a dynamic table name using the original file name of the data source (for an excel data source)

hello, i want to load the multiple tables from local database"mysql workbench" to azure lake gen 2 at a time can you tell me how can we do it? if possible make a video on it

Can you do this for Python please?

We can supply the array variable to a stored proc and use sql computation to sort and provide the latest file name.