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









 



10 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. 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
  3. 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
  4. How do I get money back from Scammers? Reach out Recovery Masters.I must give special thanks to Recovery Masters,Specialised hackers in Cryptocurrency Recovery  and lost Bitcoin wallet tracing,My wife and I happened to be scammed by an online scammer who claimed to be professional and knowledgeable in the field investments.I and my wife had agreed to invest our savings pounds worth $623,400 in form of Crypto. This scammer persuaded us to invest in an online platform called Cryptos-seed.com.''I was persuaded to deposit the funds to platform that would generate us much profits on a daily basis.The profits generated significantly,but on asking on how my withdrawal of the funds,the swindler provided multiple excuses and was asking me to invest more funds.On search on how to recover The lost funds I came through Recovery Masters who were able to recover a significant portion of the lost funds.Contact them through; Mail Recoverymasters@email.cz                         Whatspp; 1(204){ 819}-{5505}

    ReplyDelete

  5. With all of these articles on the Internet about various types of cryptocurrency scams, people haven't begun to raise their doubts about investments that offer a high return with little or no risk,
    and don't let anyone bully you into making decisions you don't want to make.
    Because these phony investment platforms thrive on greed, which we all have, but only if we choose to let it cloud our judgment.
    This would be your most powerful weapon in the fight against scammer in general.
    My cousin has been a victim of these scammers a few times, but I believe it is because she lived in the United States that she was always unaware of the false internet impossibility scheme creating organization.
    she and her broker friends have been recovering their lost funds with(claimpayback.com) so checking them out at this point wouldn't be a bad option if you have been scammed at this point of your bitcoins or your investments..
    Best of luck with getting back your money.

    Collect all the raw information (all emails, dates and times, phone numbers or call logs, the bitcoin ATM into which you put your cash or other currency exchange details).
    Take that all that raw data to an institutions with technological resource that make it easy to track down a large number of significant bitcoin addresses.

    You stand a high chance of recovering your bitcoin from a scammer when you report to the right investigative and regulatory authority.
    If you notice you have fallen for a bitcoin scam, you can file a report by sending a well-detailed mail to support@claimpayback.com

    ReplyDelete
  6. IS IT POSSIBLE TO ACTUALLY GET BACK FUNDS LOST TO CRYPTOCURRENCY SCAM? ABSOLUTELY YES! BUT, YOU MUST CONTACT THE RIGHT AGENCY TO ACHIEVE THIS.

    DARK WEB ONLINE HACKERS is a financial regulator, private investigation and funds recovery body. We specialize in cases concerning cryptocurrency, FAKE investment schemes and recovery scam.

    Visit darkwebonlinehackers.com now to report your case or contact our support team via the contact information below to get started.

    dwchzone@gmail.com

    WhatsApp: +1 (803) 392-1735

    Stay Safe !

    ReplyDelete
  7. I’m Joyce Dole from Richmond, Texas. I was scammed of $127,000 a few weeks ago when I was introduced to cryptocurrency investment opportunities. They locked my account and requested more money before I could access it, and that was how I realized I was being conned. I’ll advise people to be wary of these crypto investment companies as they are all out to steal from you. I was very lucky to come across a cryptocurrency recovery company Spyweb Cyber Security Service who was able to recover my money successfully without any delay. Spyweb Cyber Security Service is a professional and reliable cryptocurrency recovery company and I’m truly grateful for their service. I highly recommend them to everyone who wishes to get back their cryptocurrency funds.

    THEIR EMAIL IS: SPYWEB @ CYBERDUDE . COM
    WHATS APP: +1 (323) 904 ‑ 8824

    Thank you.

    ReplyDelete
  8. Get $2,000 USD everyday for 2 Yeras. Contact for more info email: ( darkwebonlinehackers@gmail.com ) or WhatsApp number : ( +18033921735 )

    ReplyDelete
  9. Get $2,000 USD everyday for 2 Years. Contact for more info email: (ethicsrefinance @ g mail com ) TELEGRAM :@ethicsrefinance

    ReplyDelete
  10. Telegram: "CyberGenieHackPro"

    If you ever find yourself in a situation where you are hopeless with no one to trust or sincerely confide in because you trusted a bunch of crypto traders and you are on the brink of losing thousands or millions of dollars you have invested with them, I tell you this, worry no more, CYBER GENIE HACK PRO is your redemption. Losing is always hurtful, trying recovering your stolen and lost money with the help of CYBER GENIE HACK PRO.

    ReplyDelete