How to Load Data from Multiple XL Sheets to Azure SQL Tables in Azure Data Factory

Issue: How to Load Data from Multiple XL Sheets to Azure SQL Tables in Azure Data Factory.


In this article, we are going to learn how to load data from multiple, EXCEL sheets to Azure SQL Tables in the Azure Data Factory, let's start the demonstration.

How to Create a pipeline:


Open the Azure Data Factory Studio, Go to the author tab, click on pipelines, then click on New pipeline.


Click on the white working window, then go to the parameters tab, click on the + New button,  provide the name, type, and default value. 



Find and drag the ForEach loop activity, go to the settings tab, click on items and add the parameter we created earlier.


Next, go inside the ForEach loop Activity, find and drag the copy data activity, go to the source tab, click on the + New button to create a new source dataset.


Select Azure blob storage then click on continue.


Select format as Excel then click on continue.


Name your dataset, select the linked service, select the file path, select the file, Worksheet mode will be Name, select none for import schema,  then click on ok.


In the source tab click on the Open button, go inside and create a parameter.


In the parameters tab, click on the + New button, then, name the parameter, select the type, give the default values, then go to the connection tab.



In the connection tab, use the parameter which we just created.


Back to the source tab, provide the values from our ForEach loop Activity.


Once we are done with our source tab, go to the sink tab, click on the + New button to create a new Sink dataset.

Select Azure SQL database, then click on continue.


Name your dataset, select the linked service, select none for import schema, then click on ok.


In the sink tab, click on the Open, go to the Parameters tab, click on the + New button and create a parameter.


Go to the connection tab and use the parameter that we just created.


Now map this parameter with our ForEach loop, then click on Debug.




Video Demo: How to Load Data from Multiple XL Sheets to Azure SQL Tables in Azure Data Factory









 



5 comments:


  1. CRYPTO RECOVERIES AND OTHER TROUBLESHOOTS.


    Outside various bitcoin online trading communities...
    we are strictly rendering fast help to those bitcoin online investors facing various issues

    left unattended by their wallet accounts SERVICE PROVIDER (team supports),leaving you hanging and lost on how to go about getting help. 

    EG:

    BLOCKSTREAM (blockchain)

    Blockstream employs a number of prominent bitcoin core developers and is one of the largest 

    contributors of the software's funding.The company has been attempting to make it possible 

    to "break off" transactions from the bitcoin network,

    making the number of "REGISTERED ACCOUNT’S TROUBLESHOOT TICKETS” the network 

    could handle less important and most time not even looked into as there are 

    millions of “REQUEST TICKETS” on the team supports cue.



    "BE SMART ENOUGH”, to know these companies don’t even care if ONE out of more than a million customers they got is in need of support after getting scammed and etc.

    for example:


    1️⃣ NONSPENDABLE BITCOIN ACTIVATION! 


    2️⃣STOLEN BITCOIN$(fake FX trading platforms)! 



    3️⃣LOST PASSWORD GLITCH! 



    4️⃣TWO FACTOR AUTHENTICATOR PROBLEMS! 



    5️⃣LOST ID OR PASSWORD GLITCH! 



    6️⃣HACKED ACCOUNTS ! 



    7️⃣ RECOVERY OF CRYPTO (BINARY LOSSES & STOLEN FUNDS) 


    8️⃣PHISHING OF BITCOIN ACCOUNTS PROBLEM! 



    9️⃣LOGIN ERORS! 



    10.SCAMMED DURING BITCOIN TRADINGS (WITHDRAWAL ISSUES). 



    cases like these get your crypto funds trapped (likely lost forever,until you meet the right agents like "US").


    NOTE:
    COINBASE/TEAM-SUPPORT

    BINANCE/TEAM-SUPPORT

    KRAKEN/TEAM-SUPPORT

    BITFINEX/TEAM-SUPPORT

    HITBTC/TEAM-SUPPORT

    LOCALBITCOIN/TEAM-SUPPORT

    BLOCKCHAIN/TEAM-SUPPORT

    team supports listed and ones not listed above can’t solve your problem 100%.

    How long do you have to wait when we can provide you legit CERTIFIED hackers with past works dealt with without having to wait long until your troubles are sorted?

    START SENDING YOUR TICKET PROBLEMS IN NOW FOR ULTIMATE SOLUTION!


    ◾compositehackers@protonmail.com

    Composite Hackers
    2022 ©.

    ReplyDelete
  2. I know an organization who have private investigators for hire who can help you get into your spouse’s phones,emails remotely from your phone they can also help you with your
    * credit score
    * clearing of criminal record
    *increasing of school grades etc
    You can confirm for yourself from their email support@wavedrive.tech or website https://wavedrive.tech so you can also give your testimony
    Whatsapp No: +14106350697

    ReplyDelete
  3. LOOKING FOR AN EXPERIENCED HACKERS? Team, with an excellent track record in Our field, provides enviable services. We Offer the following services at affordable rates. * Deletion of Criminal records * Hack Databases * Sale of Dumps cards of all kinds * Unfeasible IP * Hack single computers * Hack websites * Facebook hack * Controllers remotely controlled contact via... digitacardhacker@gmail.com Whats App via +16204077220

    ReplyDelete
  4. SCAM / FRAUD TRACING & RECOVERY CONTACT RECOVERY MASTERS

    I happened to be a romance scam victim,During the summer late last year I happened to accept a facebook friend request from a good looking stranger who described himself as a swedes neurologists working in Iran and called himself Oliver.After a couple of months of daily communication on encrypted messenger app,Oliver started asking for money,and in a span of two months I had given the guy and two people claiming to be his children some $78,000 funds,on realizing its a scam, he had already swindled me out all My late husband's life insurance,my pension and all my lifetime savings,leaving me helpless and devastated.Luckily,it wasn't too late, through my late husbands friend lead I learnt through Recovery Masters a firm specialized in funds recovery from all sort of scams.To my disbelief all my funds was recovered back.To anyone in need of their services
    Contact Support Info Mail;(Recoverymasters@email.cz)
    whatsapp;+1(204)819-5505.

    ReplyDelete
  5. HOW TO MAKE $20,000 ON PAYPAL

    CONTACT:(ethicsrefinance@GMAIL.COM)
    WEBSITE:(WWW.ETHICSREFINANCE.COM)

    Hello everyone i just successfully made over $20,000 from ethicsrefinance@gmail.com, through their paypal hack transfer services , they very fast and reliable to earn from them , i was able to pay for my rent and other house bills , am forever grateful to them .THEY AER LEGIT !

    ReplyDelete