How to Create & Load Tables in Azure SQL Database from On-Prem SQL Server Database

 Issue: How to Create & Load Tables in Azure SQL Database from On-Prem SQL Server Database.

In this article, we are going to learn, how to crate and load tables in Azure SQL database from on-prem SQL server database, lets start our demonstration.

How to connect On-Prem Azure SQL database with Azure SQL database:

Open your SQL Server Management Studio and connect with the Azure SQL database, Provide the server name, then select the authentication type, then provide your user name & password and then click on connect.

Once we are connected with the Azure SQL database, go to the Azure Data factory studio, then go to the author and then click on + sign to create a new pipeline, then find and drag the lookup activity, then click on settings and then click on + New to create a new source dataset, from where we will read the list of tables which we have to copy to our Azure SQL database.

Find and select the SQL server and then click on continue.

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

Next, in the settings tab click on the query, and write the query to obtain list of the tables.

Next, find and drag the ForEach loop activity, then connect with the Lookup activity, then go to the settings tab and click on ''Add dynamic content''.

Now, go inside the ForEach loop activity by clicking on a Pencil sign on the ForEach loop activity then find and drag the copy data activity, then go to the source tab and then click on + New button to create a new source dataset.

Find and select the SQL server and then click on continue.

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

Next, in the source tab click on the Open button to create a parameter as we dont select the table name because ww have to rad the all tables from our on-prem, in that case we have to create a parameter and that parameter we will use in our connection. go to the parameter tab then click on + New, then create a parameter.

Then in the connection tab, provide the schema name then select the parameter which we have created and then go to the pipline.

Now go to the sink tab, and click on + New button to create a new sink dataset.

Select Azure SQL database and then click on continue.

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

Now, create a parameter and provide the values for the sink datset set where we will write our files and then debug the pipeline.

Video Demo: How to Create & Load Tables in Azure SQL Database from On-Prem SQL Server Database



    ❌ Binary Option, Forex and their likes are a means of making money but it’s more like gambling. There are no sure means to guarantee that a person could make profit with them and that’s why it can also be reasoned to be scam. Let’s not forget that some individuals even give you đŸ’¯ % guarantee of making profits and end up running away with your money. The internet today is full of Binary Option Recovery Scam, you see so much testimonies been shared about how a firm or Company helped them recover what they lost to Binary Options. But believe it, it’s just a way to lure more people and end up scamming them.

    ❌ You might have also come across some individuals that say they will give you guarantee on successful trades but they only end up as SCAMMERS as well. You here them say stuffs like 200% guaranteed in just 2 weeks and when you go into trade with them, they start telling you to pay profits percentage before you can get your income. These are all liars please avoid them. But if you have been a victim of this guys, then you should contact FIRMWARE now‼️

    ✳️The big Question is “Can someone Recover their money lost to Binary Option and Scam⁉️
    I will say yes, and will tell you how.

    The only way to Recovery your money back is by hiring HACKERS to help you break into the Firms Database Security System using the information you provide them with, Extract your file and get back your money. It seems like a really impossible thing to do, I will tell you, it should be impossible, but with the use of specially designed softwares known to HACKERS and Authorities (such as The FBI, CIA e.t.c) it is possible and the only way to recover your money.

    ✅FIRMWARE are a group of hackers who use their hacking skill to hunt down SCAMMERS and help individuals recovery their money from Internet SCAMMERS.
    We just need the contact details of the SCAMMERS and Paymnet Info and within 4-8 hours your money will be return to you.

    ✳️ You can contact us via the emails below-:

    We also provide Legit Hacking Services such as-:
    đŸ”¸Phone Hacking/Cloning
    đŸ”¸Email Hacking & Password Recovery
    đŸ”¸Social Media Hacking & Passowrd Recovery
    đŸ”¸Deleted Files Recovery đŸ”¸Mobil Tracking
    đŸ”¸Virus detection & Elimination.


    2022 © All Right Reserved.

  2. Have you lost your hard earned money to:1.Binary option scam??
 2. Forex trading?
 3.Romance scam
?? 4. Expertoption scam?? and any other kind of online investment? 
I have a good news for you. Contact Recoverbtchelp07 
 I had doubts it was possible to recover the funds I lost to binary options. However, big thanks to Recoverbtchelp07 now for helping me recover a huge sum back and still working on full recovery for me.
 They are nothing but the best. You should contact them now!! and have a taste of quick funds retrieval with no upfront payment and tricks... Don’t be deceived by the fake assess. Nothing can be compared to peace of mind and excellent service. The real deal is Recoverbtchelp07 at gmail dot com for an outstanding and honest service.......... Whatsapp or text: +1 315 784 1311

    I was scammed of $379,000 worth of bitcoin with a scam forest investment unknowingly then,
    I didn’t know what to do.. I felt like committing suicide, but fortunately for me, my friend introduced me to a cyber crime investigator ( Mr Morris Gray )who also helps in recovering lost invested funds, After working with him, to my greatest surprise, in just few days I got all my lost funds back, and he only took just 15% out of the recovered funds, if you have been scammed with fake forex you don’t need to be scared or worried, because you can also reach him on his email: MorrisGray830@ gmail .com
    He will recover your lost bitcoins back fast and smoothly...
    You can WhatsApp him via +1 (607) 698-0239.
    And you will be amazed….!!!


    Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS

    Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. BEATE HEISTER LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via Whatsapp; +1 (540) 209-1989

    Services rendered include:

    *Refinancing Loans
    * Car Loan
    *Truck Loans
    * Home Loan
    * Mortgage Loan
    * Debt Consolidation Loan
    * Business Loan [secure and unsecured]
    * Personal Loan [secure and unsecured]
    * Students Loan and so many others.

    For more info; Contact us via Email: or Whatsapp; +1 (540) 209-1989 With Prof. Mrs. BEATE HEISTER LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic

  5. Buy Legit Passports, Id Cards, Drivers License And Much More (obtain Full Nationality For Any Country), Passports, ID cards, Drivers license, Working permits, Birth/Marriage certificates(Whatsapp:+19254121971)(

    Buy Legit Passports,Id Cards,Drivers License And Much More(Whatsapp:+19254121971)(

    Buy Legit Passports,Id Cards,Drivers License And Much More(obtain Full Nationality For Any Country)(Whatsapp:+19254121971)(



    New Citizenship!!USA/UK/Canada/Australia/EU;Passports,Visa,ID cards,Drivers License,USA Greencard(Whatsapp:+19254121971)(

    Buy Real and Fake Passports,Drivers license, Citizenship Documents Online(Whatsapp:+19254121971)(

    Buy Real and Fake Passports,Visas,Drivers License Online(Whatsapp:+19254121971)(

    Buy Real and Fake Drivers License Online(Whatsapp:+19254121971)(

    Buy Registered Passports,Drivers License Online(Whatsapp:+19254121971)

    Buy Fake Passports Online(Whatsapp:+19254121971)(

    Buy Fake Drivers License Online(Whatsapp:+19254121971)(

    Buy Legit Passports Online(Whatsapp:+19254121971)(

    Buy Legit Drivers License Online(Whatsapp:+19254121971)(

    Buy Registered EU/USA/UK/Canadian Passports,Driver’s License,ID Cards,Visas, USA Green Card,Citizenship(Whatsapp:+19254121971)(

    get passport online(Whatsapp:+19254121971)(

    citizenship application online(Whatsapp:+19254121971)(

    get my passport online(Whatsapp:+19254121971)(

    buy real passport online(Whatsapp:+19254121971)(

    immigration and naturalization service(Whatsapp:+19254121971)(

    buy registered passports online(Whatsapp:+19254121971)(

    Registered passports online(Whatsapp:+19254121971)(

    Citizenship online(Whatsapp:+19254121971)(

    Online driver's license(Whatsapp:+19254121971)(

    buy registration id card online(Whatsapp:+19254121971)(

    buy real id cards online(Whatsapp:+19254121971)(

    buy birth certificate online cheap(Whatsapp:+19254121971)(

    buy social security card online(Whatsapp:+19254121971)(

    buy copy marriage certificate uk(Whatsapp:+19254121971)(

    buy emancipation certificate online(Whatsapp:+19254121971)(

    Buy SSN Online(Whatsapp:+19254121971)(

    Buy high quality Passports USA(Whatsapp:+19254121971)(

    Buy UK Drivers License(Whatsapp:+19254121971)(

    Buy UK registered passport(Whatsapp:+19254121971)(

    buy genuine passport online(Whatsapp:+19254121971)(

    buy genuine passport online(Whatsapp:+19254121971)(

    buy real registered passport online(Whatsapp:+19254121971)(

    buy ssn card online(Whatsapp:+19254121971)(

    buy real driver's license online(Whatsapp:+19254121971)(

    buy real registered drivers license(Whatsapp:+19254121971)(

    buy real and fake drivers license online(Whatsapp:+19254121971)(

    apply for citizenship online(Whatsapp:+19254121971)(

  6. hack into email accounts and trace email location -all social media accounts, -school database to clear or change grades, -Retrieval of lost file/documents -DUIs -company records and systems, -Bank accounts,Paypal accounts -Credit cards hacker -Credit score hack -Monitor any phone and email address -Websites hacking, pentesting. -IP addresses and people tracking. -Hacking courses and classes CONTACT THEM=, Whatsapp No: +14106350697 their services are the best on the market and 100% security and discreet work is guaranteed.

  7. Have you heard about Cryptocurrency, bitcoin, Ethereum or Dogecoin? It's the trending form of investment that can change your financial status for the better. This was how I got to meet with the wrong platform for crypto investment and was duped over $100,000 USDT. This was supposed to be an investment plan that will change my life and sustain me for years ahead. I was ripped off and didn't know where or how to go about it. While surfing through the internet, I came across a pop up talking about Spyware Cyber and how they help victims recover stolen funds. This was quite scary to me but I chose to see how it would turn out. After few days of investigation , I got back my lost funds in full. I am so happy as I have decided to let the world also know about their effective service. Their contact information is as follows: spyware(@)cybergal(.)com

  8. Have you ever been a victim of a romance scam? Have you been defrauded of your hard-earned money by these online scammers pretending to be investors on Instagram? If you have lost your cryptocurrency or sent cryptocurrency to these online scammers before then you have absolutely nothing to worry about as wardrivers are here to help you recover whatever you must have lost to these online scammers. I was in the same situation as you until I came across an article about Wardriver's cyber service and how they can help me recover my lost funds, I didn't believe them at first but after giving it a try, I was able to recover my $807,000.00 that I lost to cryptocurrency investment scam in 48 hours. This recovery company is known for how effective its services are. They carefully analyze the information sent to them and track down these scammers, Wardrivers ensures your funds are returned to you without leaving a penny behind and the scammers are handed over to the authorities for further investigation. Don't hesitate to contact Wardriver's cyber-service at EMAIL: ( wardriverscyberservice(@)techie(.)com) WhatsApp: +1 ( 6 1 6) 8 9 8-7 2 8 5

  9. Best Hacker Contact RecoveryMasters

    I was in need of a very good hacker then i was referred to these wonderful hackers named RecoveryMasters who helped me hack into my spouse phone without my spouse knowing such a hack was done on his phone RecoveryMasters hacked into my spouse whats-app messages, call logs, text messages, deleted text messages, Viber, emails and many more i got result under 24 hours and I found out my spouse has been a big time cheat thanks to these great hackers you all can also contact them via email ( ) or whatsapp +1(551) 202-23-35 if you have any form of problem. They are solution makers. Tell them Hina referred you to them and I am sure they will help you with your proof.

  10. I lost $780,000 worth of Bitcoin to a fake online coin investment company called Coin Flip Trade and I was about to lose my mind, but digital triangulation expert Kravitz Hein of (claimpayback on google) went out of his way to help me recover every single coin stolen from me after I had provided the adresses and transaction hashes generated by providing me with links and steps when I was about to lose my mind.
    They went on to explain that these guys have a leverage wallet linked to their phony investment platform, which they use for trading.
    Thank you very much.
    You can contact him about any recovery issue.
    I recently detached 65btc from the the outsourced wallets. im waiting for the Erc20 gas fee to be able to detach the rest

  11. Good day everyone, I’m Doris Keeton and I wish to bring to your attention the service of the Spyweb Cyber team who helped me recover my stolen money. A few weeks ago, I was contacted on Instagram by someone pretending to be an account manager and forex investor, I was convinced to invest a huge sum of money through Bitcoins and Ethereum, I sent a total of $77,000 to this person and I was scammed off my money. I was really sad and frustrated, but while I was going through the pain of losing my money, a friend of mine told me about Spyweb Cyber recovery team, a genuine and reputable team with plenty of good reviews, I contacted them immediately and provided all the information they needed, and to my surprise, they recovered all the money that I lost. I highly recommend Spyweb if you need any assistance in recovering your money from these scammers.
    (Spyweb@cyberdude. com)
    (Contact@spyweb. tech)

  12. After falling victim to fraud twice trying to recover my stolen USDT, I gave up on the possibilities of ever being able to have it recovered until Gear Head Cyber Panacea was recommended on Quora and I was very grateful to have come across the article as they recovered 85% of my stolen USDT and so I decided to share this for anyone else that might be in need of their services. You can reach them on com or check out their website ( or Text him on +1(818) 855 7389 )

  13. I never thought I could get scammed of my Bitcoin , I never knew these investments were fake . I never knew I was getting lured into loosing my money , I was depressed and in anger but all thanks to Hacker Judas for the help and professional service offered to me in my time of need . Thanks to jane for sending me his WhatsApp contact: +19124053415 and email. He helped me recovered my lost funds from the scammers. I couldn’t believe it i swear.

  14. hire an outsourced security developers from Ukraine with us to manage your cyber security needs, you can benefit from their 24/7 support and monitoring services. This means that your business will be protected around the clock, and you can rest assured that any potential threats will be identified and addressed quickly.Hire Cybersecurity Consultants | CISSP & IAPSC Certified

  15. Good day to everyone on this web site! When hiring remote RPA engineers for part-time or full-time projects, there are some specialists that businesses need to consider to ensure they get the right talent for their needs. For example you need to know more information about different RPA Team Leaders.

  16. I have no much to say here cos i can see that, there's much comments here about All i can say here is thanks to you Judas my wife can trust me now we got all our lost Bitcoin back.


    As a business-minded individual, I despised staying at home, saving all my pensions and not being able to use them to make more money, so I went on the lookout for an investment. I tried binary options and forex, lost some money, and took a break from the online investment thing until I came across a so-called investor guru. I put a lot of money into him and never received it back. I saw articles on Recovery Masters how they have helped victims recover their lost funds and btc. Despite the fact I was at first dubious about the whole thing, l contacted them via their email. Truly grateful for their splendid service and support.. Contact them to recover your lost BTC or money.

    Email address: ( )
    (On WhatsApp, dial +1(204)8195505


    It is truly amazing what you can achieve with the right information. I’m truly grateful for the service of AstraWeb Cyber Security Network, which was able to recover my cryptocurrency funds from fake investment accounts. Losing $184,000 of my hard-earned money was excruciating and devastating when I thought I could earn more from investing in cryptocurrency, not knowing that I had fallen for a scam. I was able to contact AstraWeb Cyber Security Network when I did my research online and came across their website www.astrawebcybersecurity. net
    I saw that AstraWeb Cyber Security Network has been helping many victims like me to recover their funds.
    I’m truly grateful for their service and I commend them for being professional and trustworthy.
    Their contact information is below

    E-Mail: AstraWeb@Cyberdude. com

    Thank you for your time.

  19. TESTIMONY ON RECOVERY OF MY LOST BITCOIN FUNDS : Have you ever being a victim of scam? or have you lost your money to fake brokers online? I implore you to contact this trustworthy hacking sevice/recovery experts named SPYHOST CYBER SERVICES. I was a victim of fake people posing as binary options and bitcoin investors, I lost a sum of $237,000 to this fake brokers. it took a while before i realized they were scams and this really hurt me and indeed was the biggest mishap of my life. Then an inlaw of mine heard about it and recommended to me a special company in the hacking field. They helped me recover my lost bitcoins in less than 72hrs and the fakes where caught and made to pay for what they did to me . if you have lost any amount to online scams either through online dating scams,btc wallet hack, fake binary investments and you are in need of help Reach out to SPYHOST CYBER SERVICES,and you will be so glad you did so, here is the address through which you can reach them at: SPYHOST@CYBERDUDE. COM

  20. Hello everyone here, about 4 months ago I saw an opportunity to invest in cryptocurrency and I decided to take my chance. I contacted the broker whose adverts I saw on Facebook. I invested around $331 k which was deposited using bitcoin with hopes to gain massive returns on my investment. I kept tracking my portfolio and it was increasing daily on the website; this made me excited and confident. Fast forward to 30 days later which was supposed to be my payout date, I tried to make a withdrawal as I wanted to buy a house, but the broker insisted that I continue to invest or will have to pay some fees to be able to withdraw my funds.. That was disappointing to hear because it was all going smoothly when I deposited the funds. Eventually, I paid the fees which was about $38 k. I was beginning to be desperate because according to my portfolio I had made about $ 800 k. It however turned out this was a scheme to keep asking me for more money for one thing or the other like taxes, miner’s fee and so many others. I declined to pay any more money and then they went ahead and locked my account. This made me had suicidal thoughts because I was left with absolutely nothing in life; until after a few weeks I explained the situation to my younger sister who then introduced me to a hacking agency called REFUND POLICY, they told me to not worry that they were capable of getting my money recovered. With only little faith in me I decided to work with them and I tell you it was like a dream in less than a week they recovered all the bitcoin I had sent to them.

    I want to thank this medium to thank REFUND POLICY for their great assistance to me and also want to recommend them to anyone that mind find themselves in the type of situation I found myself and needs their services. Their email address is refundpolicy82 at gmail dot com , WhatsApp +1 626 770 5974.

  21. Considering Pro Wizard Gilbert Recovery assists consumers in recovering lost cryptocurrency cash, I chose to try out their services. I can attest to Pro Wizard Gilbert Recovery because I employed their service after I suffered a substantial financial loss due to a questionable online cryptocurrency investment. To be quite honest, I had my doubts at first, but to my astonishment, they were able to find my missing money in just a few weeks. Pro Wizard Gilbert Recovery worked with professionalism and effectiveness. All I have done up to this point is admire their efforts, thus I made the decision to educate the public of how excellent Pro Wizard Gilbert Recovery is. Email them at: prowizardgilbertrecovery(@) ~ WhatsApp +1 (859) 443‑5876 to get in touch with them

  22. They are all scammers, they will make you pay after which they will give you an excuse asking you to pay more money, they have ripped me of $82000, i promised i was going to expose them. I figured it all out when my colleague introduced me to SPYHOST CYBER SERVICE ( . This hacking firm did a perfect job . Ad also,they are specialists when it comes to hacking all accounts ranging from (Emails, Facebook, whatsapp, imo, skype, instagram, Phone cloning, DMV removal, tracking locations, background checks Kik etc. They also hacks cell phones, cell phone tapping and cloning, clears bad driving and criminal records, bank transfers, locates missing individuals e.t.c. You should contact them and please stop using contacts you see on websites to execute jobs for you, you can ask around to find a real hacker like SPYHOST

  23. My misplaced cash of roughly $180k were found and recovered. I had my trading money unloaded by a broker who for three months refused to give me access to my trading account, and I had no idea that I would be able to recover it. That I could get my money back without any hassle makes me quite happy. Elite Wizard Bitcoin Recovery, who earned a reputation as a licensed binary options recovery specialist, is a technician I would really like to thank. Your broker manager is recommending that you make further deposits before making a withdrawal if you have money in your account that you intend to take out. Please get in touch with Elite Wizard Bitcoin Recovery using the information below if you are unsure how to proceed. In a matter of days, they will demonstrate to you the guild lines to recover your stolen funds.


    Phone: +1 (740) 688-0116

  24. I was absolutely impressed with SPYHOST cyber service's high professionalism and hacking prowess.They successfully recovered my lost password after a few hours of deploying their equipment to allow BIP38 decryption of the private key for Doge I'd held since 2016. There is obviously a high level of trust involved in handing over keys and possible passwords but carrying out my due diligence with reviews and one recommendation from someone I already knew, gave me the confidence I needed. The Doge was worth 100's of thousands of dollars and he deducted the agreed commission and assisted me with getting it safely to my exchange. I've since monetized the coin so it's real. Mightily impressed and grateful for his service after somewhat giving up on thinking I would never realize the substantial theoretical gain. I gave SPYHOST as many seeds of various passwords I had been using around that era and as much information I could help and that greatly assisted the task. Their tech skills and equipment were just what were needed for the job and wish him all the success with lots more enquiries. You can also contact them through their email which is: Spyhost@cyberdude .com

  25. How Mighty Hacker Yuri claimed Victory over the Cryptocurrency Scammers
    Thanks to Mighty Hacker Yuri, I went from feeling defeated and lost to being filled with hope and excitement for the future. His expertise in recovering my cryptocurrency and elevating my credt score saved me from the depths of despair. Mighty Yuri truly is an extraordinary force to be reckoned with. My Name is Dawn David
    I Lost $401,800 in USDT and Bitcoin, Mighty Hacker Yuri Recovered it all. A big Thanks to Mighty Hacker Yuri again. If you require any specific details or would like to add any personal anecdotes, contacts Mighty Hacker Yuri
    mightyyuri@consultant . com
    whatsap or Call
    +1,828, 630, 8408.

  26. It's been hard losing a lot of my money to these Online scammers. I found an investigative Company ASSET CRYPTO HACKER, who made sure I got everything back. If your case is similar, you can consult them on how to get your money back.
    Whatsapp: +39,35,10,77,77,69

  27. I came in hand with greatness today, after mysteriously losing control of my Binance wallet and my trading account to LCGCOIN, I did everything they asked me but truth be told, this LCGCOIN crypto trading platform is just a bunch of rippers and clowns who prey on us due to our lack of exposure about cryptocurrency and how to properly earn from it. I saw no end to their demands for them to allow me access to my Binance wallet and trading account with them as well. I hired a private detective in my city, Oklahoma and he confirmed to me they were crooks but he couldn't do much so he introduced me to Cyber Genie Hack Pro Crypto Wealth Recovery Services. I consulted them and filed a case on their website ( ht tp (://)   cybergeniehackpro (.) xy z/  ), and they swiftly got into work. I am truly impressed with the outcome of their recovery services. Having back access to my money was all I wanted. Every dollar I ever deposited into my LCGCOIN trading account was recovered. Everything is in order and my security is tight to avoid further cyber attacks. Grateful to everyone that made the recovery a success at Cyber-Genie-Hack-Pro. File a case with Cyber Genie if you are a victim of Binary and Cryptocurrency trading fraud. TELEGRAM:  @CYBERGENIEHACKPRO
    WHATSAPP:  (+) (1252) (5120391)